252: AND pap.accrual_plan_id IN
253: (SELECT papl.accrual_plan_id
254: FROM pay_accrual_plans papl,
255: pay_element_links_f pel,
256: pay_element_entries_f pee
257: WHERE pel.element_type_id =
258: papl.accrual_plan_element_type_id
259: AND cp_effective_date
260: BETWEEN pel.effective_start_date