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_RUN_RESULTS

Line 25: and exists(select * from pay_run_results

21: AND paa.payroll_action_id = ppa.payroll_action_id
22: AND paa.action_status='C'
23: AND ppa.action_type in ('R','Q','V','B','I')
24: AND ppa.date_earned between pas.effective_start_date and pas.effective_end_date
25: and exists(select * from pay_run_results
26: where assignment_action_id=paa.assignment_action_id
27: and (element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages'), Get_Element_Type_Id('Wage Tax Subsidy Education')
28: , Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed') , Get_Element_Type_Id('Wage Tax Subsidy Paid Parental Leave'))
29: or element_type_id in (Get_Element_Type_Id('Retro Wage Tax Subsidy Low Wages'),Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed')

Line 179: pay_run_results prr

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
183: and paa.assignment_id = pas.assignment_id

Line 279: and exists(select * from pay_run_results

275: and hoi.organization_id=hou.organization_id
276: and hoi.org_information3 IS NOT NULL
277: and hoi.org_information4 IS NOT NULL
278: and hoi.org_information_context='NL_ORG_INFORMATION'
279: and exists(select * from pay_run_results
280: where assignment_action_id=asg_act.assignment_action_id
281: and (element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages'),
282: Get_Element_Type_Id('Wage Tax Subsidy Education') ,
283: Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed')

Line 356: pay_run_results prr,

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
360: and asg_act.assignment_action_id = l_asg_act_id

Line 380: and exists(select * from pay_run_results where assignment_action_id=asg_act.assignment_action_id and

376: --10160211
377: ,Get_Element_Type_Id('Wage Tax Subsidy Increasing Education Level')
378: --10160211
379: )
380: and exists(select * from pay_run_results where assignment_action_id=asg_act.assignment_action_id and
381: element_type_id in
382: (Get_Element_Type_Id('Wage Tax Subsidy Low Wages'),
383: Get_Element_Type_Id('Wage Tax Subsidy Education')
384: ,Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed'),

Line 453: pay_run_results prr,

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
457: ppa.business_group_id=p_bg_id

Line 478: and exists(select * from pay_run_results where assignment_action_id=asg_act.assignment_action_id and

474: --10160211
475: ,Get_Element_Type_Id('Retro Wage Tax Subsidy Increasing Education Level')
476: --10160211
477: )
478: and exists(select * from pay_run_results where assignment_action_id=asg_act.assignment_action_id and
479: element_type_id
480: in (Get_Element_Type_Id('Retro Wage Tax Subsidy Low Wages'),
481: Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed')
482: ,Get_Element_Type_Id('Retro Wage Tax Subsidy Education'),

Line 880: from pay_run_results

876: and hoi.org_information3 IS NOT NULL
877: and hoi.org_information4 IS NOT NULL
878: and hoi.org_information_context='NL_ORG_INFORMATION'
879: and exists(select *
880: from pay_run_results
881: where assignment_action_id=asg_act.assignment_action_id
882: and (element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages')
883: ,Get_Element_Type_Id('Wage Tax Subsidy Education')
884: ,Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed')

Line 960: pay_run_results prr,

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
964: and asg_act.assignment_action_id = l_asg_act_id

Line 985: from pay_run_results

981: ,Get_Element_Type_Id('Wage Tax Subsidy Increasing Education Level')
982: --10160211
983: )
984: and exists(select *
985: from pay_run_results
986: where assignment_action_id=asg_act.assignment_action_id
987: and element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages')
988: ,Get_Element_Type_Id('Wage Tax Subsidy Education')
989: ,Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed')

Line 1065: pay_run_results prr,

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
1069: ppa.business_group_id=p_bg_id

Line 1091: from pay_run_results

1087: ,Get_Element_Type_Id('Retro Wage Tax Subsidy Increasing Education Level')
1088: --10160211
1089: )
1090: and exists(select *
1091: from pay_run_results
1092: where assignment_action_id=asg_act.assignment_action_id
1093: and element_type_id
1094: in (Get_Element_Type_Id('Retro Wage Tax Subsidy Low Wages'),
1095: Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed'),