DBA Data[Home] [Help]

APPS.PAY_NL_WTS_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 14: per_all_assignments_f pas

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
18: AND ppa.date_earned = l_date_earned

Line 173: per_all_assignments_f pas,

169: Get_Element_Type_Id('Retro Wage Tax Subsidy Education'),Get_Input_Value_Id('Pay Value',Get_Element_Type_Id('Retro Wage Tax Subsidy Education')),
170: 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
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

Line 174: per_all_assignments_f pas1,

170: 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
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