Getting "Inavalid Parameters Requested" error for one of the parameter.

This is my LOV code:

SELECT 

MANAGER_NAME 

FROM

(

SELECT 

DISTINCT papf1.display_name MANAGER_NAME

FROM per_person_names_f papf,

PER_ASSIGNMENT_SUPERVISORS_F_V paaf,

per_person_names_f papf1,

ar_collectors COL,

ra_customer_trx_all trx,

hz_cust_accounts hca,

hz_customer_profiles_f HCPF

WHERE papf.person_id = paaf.person_id

AND papf1.person_id = paaf.MANAGER_ID

AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date

AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

AND TRUNC (SYSDATE) BETWEEN papf1.effective_start_date AND papf1.effective_end_date