eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 171: from pay_assignment_actions paa,

167: 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')),
168: 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')),
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,

Line 172: pay_assignment_actions paa1,

168: 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')),
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,

Line 247: pay_assignment_actions asg_act

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

Line 331: pay_assignment_actions asg_act,

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
334: where
335: ppa.business_group_id=p_bg_id

Line 397: pay_assignment_actions asg_act,

393: Get_Element_Type_Id('Retro Wage Tax Subsidy Education'),2,Get_Element_Type_Id('Retro Wage Tax Subsidy Paid Parental Leave'),4) Sequence
394: from
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

Line 780: pay_assignment_actions asg_act

776: per_people_f pap,
777: hr_organization_units hou,
778: hr_organization_units hou1,
779: hr_organization_information hoi,
780: pay_assignment_actions asg_act
781: where
782: ppa.business_group_id=p_bg_id
783: and paa.assignment_id = asg_act.assignment_id
784: and pap.person_id = paa.person_id

Line 887: pay_assignment_actions asg_act,

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
890: where
891: ppa.business_group_id=p_bg_id

Line 988: pay_assignment_actions asg_act,

984: ) Sequence
985: from
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