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 177: pay_payroll_actions ppa,

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

Line 178: pay_payroll_actions ppa1,

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

Line 244: pay_payroll_actions ppa,

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

Line 353: pay_payroll_actions ppa,

349: ,Get_Element_Type_Id('Wage Tax Subsidy Increasing Education Level'),6 --10160211
350: ) Sequence
351: from
352: per_assignments_f paa,
353: pay_payroll_actions ppa,
354: per_people_f pap,
355: pay_assignment_actions asg_act,
356: pay_run_results prr,
357: pay_all_payrolls_f pay

Line 454: pay_payroll_actions ppa,

450: per_assignments_f paa,
451: per_people_f pap,
452: pay_assignment_actions asg_act,
453: pay_run_results prr,
454: pay_payroll_actions ppa,
455: pay_all_payrolls_f pay
456: where
457: ppa.business_group_id=p_bg_id
458: and paa.assignment_id = asg_act.assignment_id

Line 844: pay_payroll_actions ppa,

840: ppa.date_earned,
841: ppa.payroll_id
842: from
843: per_assignments_f paa,
844: pay_payroll_actions ppa,
845: per_people_f pap,
846: hr_organization_units hou,
847: hr_organization_units hou1,
848: hr_organization_information hoi,

Line 957: pay_payroll_actions ppa,

953:
954: ) Sequence
955: from
956: per_assignments_f paa,
957: pay_payroll_actions ppa,
958: per_people_f pap,
959: pay_assignment_actions asg_act,
960: pay_run_results prr,
961: pay_all_payrolls_f pay

Line 1066: pay_payroll_actions ppa,

1062: per_assignments_f paa,
1063: per_people_f pap,
1064: pay_assignment_actions asg_act,
1065: pay_run_results prr,
1066: pay_payroll_actions ppa,
1067: pay_all_payrolls_f pay
1068: where
1069: ppa.business_group_id=p_bg_id
1070: and paa.assignment_id = asg_act.assignment_id