DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_RPT dependencies on PER_ALL_ASSIGNMENTS_F

Line 278: FROM per_all_assignments_f paa,

274: ) AS
275: CURSOR c_assact(pay_act_id pay_payroll_actions.payroll_action_id%TYPE,trans_stat varchar2)
276: IS
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