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 175: per_all_assignments_f pas,

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,
179: pay_run_results prr

Line 176: per_all_assignments_f pas1,

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,
179: pay_run_results prr
180: where paa1.assignment_action_id = l_asg_act_id