DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_ASSACT_V

Line 281: pay_jp_isdf_assact_v pjiav

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