DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_ASSACT_V

Line 280: pay_jp_isdf_assact_v pjiav

276: SELECT distinct pjiav.assignment_id, pjiav.effective_date
277: FROM per_all_assignments_f paa,
278: per_all_people_f pap,
279: pay_assignment_actions pas,
280: pay_jp_isdf_assact_v pjiav
281: WHERE paa.person_id between p_start_person_id and p_end_person_id
282: AND paa.person_id = pap.person_id
283: AND sysdate between pap.effective_start_date and pap.effective_end_date
284: AND sysdate between paa.effective_start_date and paa.effective_end_date