APPS.PAY_NL_WTS_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 13: pay_payroll_actions ppa,

9: CURSOR csr_get_last_asg_act_id(l_person_id NUMBER,l_payroll_id NUMBER,l_date_earned DATE) IS
10: SELECT paa.assignment_action_id assignment_action_id
11: FROM
12: pay_assignment_actions paa,
13: pay_payroll_actions ppa,
14: per_all_assignments_f pas
15: WHERE
16: pas.person_id = l_person_id
17: AND pas.payroll_id = l_payroll_id

Line 175: pay_payroll_actions ppa,

171: from pay_assignment_actions paa,
172: pay_assignment_actions paa1,
173: per_all_assignments_f pas,
174: per_all_assignments_f pas1,
175: pay_payroll_actions ppa,
176: pay_payroll_actions ppa1,
177: pay_run_results prr
178: where paa1.assignment_action_id = l_asg_act_id
179: and pas1.assignment_id = paa1.assignment_id

Line 176: pay_payroll_actions ppa1,

172: pay_assignment_actions paa1,
173: per_all_assignments_f pas,
174: per_all_assignments_f pas1,
175: pay_payroll_actions ppa,
176: pay_payroll_actions ppa1,
177: pay_run_results prr
178: where paa1.assignment_action_id = l_asg_act_id
179: and pas1.assignment_id = paa1.assignment_id
180: and pas.person_id = pas1.person_id

Line 242: pay_payroll_actions ppa,

238: ppa.date_earned,
239: ppa.payroll_id
240: from
241: per_assignments_f paa,
242: pay_payroll_actions ppa,
243: per_people_f pap,
244: hr_organization_units hou,
245: hr_organization_units hou1,
246: hr_organization_information hoi,

Line 329: pay_payroll_actions ppa,

325: Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed'),3,
326: Get_Element_Type_Id('Wage Tax Subsidy Paid Parental Leave'),4) Sequence
327: from
328: per_assignments_f paa,
329: pay_payroll_actions ppa,
330: per_people_f pap,
331: pay_assignment_actions asg_act,
332: pay_run_results prr,
333: pay_all_payrolls_f pay

Line 399: pay_payroll_actions ppa,

395: per_assignments_f paa,
396: per_people_f pap,
397: pay_assignment_actions asg_act,
398: pay_run_results prr,
399: pay_payroll_actions ppa,
400: pay_all_payrolls_f pay
401: where
402: ppa.business_group_id=p_bg_id
403: and paa.assignment_id = asg_act.assignment_id

Line 775: pay_payroll_actions ppa,

771: ppa.date_earned,
772: ppa.payroll_id
773: from
774: per_assignments_f paa,
775: pay_payroll_actions ppa,
776: per_people_f pap,
777: hr_organization_units hou,
778: hr_organization_units hou1,
779: hr_organization_information hoi,

Line 885: pay_payroll_actions ppa,

881: --RSS
882: ) Sequence
883: from
884: per_assignments_f paa,
885: pay_payroll_actions ppa,
886: per_people_f pap,
887: pay_assignment_actions asg_act,
888: pay_run_results prr,
889: pay_all_payrolls_f pay

Line 990: pay_payroll_actions ppa,

986: per_assignments_f paa,
987: per_people_f pap,
988: pay_assignment_actions asg_act,
989: pay_run_results prr,
990: pay_payroll_actions ppa,
991: pay_all_payrolls_f pay
992: where
993: ppa.business_group_id=p_bg_id
994: and paa.assignment_id = asg_act.assignment_id