APPS.PAY_NL_WTS_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 12: pay_assignment_actions paa,

8: RETURN NUMBER IS
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

Line 173: from pay_assignment_actions paa,

169: Get_Element_Type_Id('Retro Wage Tax Subsidy Low Wages'),Get_Input_Value_Id('Pay Value',Get_Element_Type_Id('Retro Wage Tax Subsidy Low Wages')),
170: Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed'),Get_Input_Value_Id('Pay Value',Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed')),
171: Get_Element_Type_Id('Retro Wage Tax Subsidy Education'),Get_Input_Value_Id('Pay Value',Get_Element_Type_Id('Retro Wage Tax Subsidy Education')),
172: Get_Element_Type_Id('Retro Wage Tax Subsidy Paid Parental Leave'),Get_Input_value_Id('Pay Value',Get_Element_Type_Id('Retro Wage Tax Subsidy Paid Parental Leave'))), prr.run_result_id, 'M')) retro_wts
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,

Line 174: pay_assignment_actions paa1,

170: Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed'),Get_Input_Value_Id('Pay Value',Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed')),
171: Get_Element_Type_Id('Retro Wage Tax Subsidy Education'),Get_Input_Value_Id('Pay Value',Get_Element_Type_Id('Retro Wage Tax Subsidy Education')),
172: Get_Element_Type_Id('Retro Wage Tax Subsidy Paid Parental Leave'),Get_Input_value_Id('Pay Value',Get_Element_Type_Id('Retro Wage Tax Subsidy Paid Parental Leave'))), prr.run_result_id, 'M')) retro_wts
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,

Line 249: pay_assignment_actions asg_act

245: per_people_f pap,
246: hr_organization_units hou,
247: hr_organization_units hou1,
248: hr_organization_information hoi,
249: pay_assignment_actions asg_act
250: where
251: ppa.business_group_id=p_bg_id
252: and paa.assignment_id = asg_act.assignment_id
253: and pap.person_id = paa.person_id

Line 355: pay_assignment_actions asg_act,

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
358: where
359: ppa.business_group_id=p_bg_id

Line 452: pay_assignment_actions asg_act,

448: ) Sequence
449: from
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

Line 849: pay_assignment_actions asg_act

845: per_people_f pap,
846: hr_organization_units hou,
847: hr_organization_units hou1,
848: hr_organization_information hoi,
849: pay_assignment_actions asg_act
850: where
851: ppa.business_group_id=p_bg_id
852: and paa.assignment_id = asg_act.assignment_id
853: and pap.person_id = paa.person_id

Line 959: pay_assignment_actions asg_act,

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
962: where
963: ppa.business_group_id=p_bg_id

Line 1064: pay_assignment_actions asg_act,

1060: ) Sequence
1061: from
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