Querying with multiple where conditions and multiple columns
If I understand correctly you can get it by using an OR condition in WHERE clause:




create table Policies 
(
    policyId int,
    status   varchar(100),
    pendDate date,
    issueDate date
);

insert into Policies values
(1, 'Pending', '20171001', null),
(2, 'Pending', '20171002', null),
(3, 'Pending', '20171003', null),
(4, 'Pending', '20171101', null),
(5, 'Pending', '20171102', null),
(6, 'Issue', null, '20171002'),
(7, 'Issue', null, '20171003'),
(8, 'Isuue', null, '20171101');



✓

8 rows affected






select policyId,
       status,
       pendDate,
       issueDate
from   Policies
where  (status = 'Pending' and extract(year from pendDate) = 2017 and extract(month from pendDate) = 10)
or     (status = 'Issue' and extract(year from issueDate) = 2017 and extract(month from issueDate) = 10)



policyid | status  | penddate   | issuedate 
-------: | :------ | :--------- | :---------
       1 | Pending | 2017-10-01 | null      
       2 | Pending | 2017-10-02 | null      
       3 | Pending | 2017-10-03 | null      
       6 | Issue   | null       | 2017-10-02
       7 | Issue   | null       | 2017-10-03



dbfiddle here