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 177: pay_run_results prr

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
179: and pas1.assignment_id = paa1.assignment_id
180: and pas.person_id = pas1.person_id
181: and paa.assignment_id = pas.assignment_id

Line 277: and exists(select * from pay_run_results

273: and hoi.organization_id=hou.organization_id
274: and hoi.org_information3 IS NOT NULL
275: and hoi.org_information4 IS NOT NULL
276: and hoi.org_information_context='NL_ORG_INFORMATION'
277: and exists(select * from pay_run_results
278: where assignment_action_id=asg_act.assignment_action_id
279: and (element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages'), Get_Element_Type_Id('Wage Tax Subsidy Education') , Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed')
280: , Get_Element_Type_Id('Wage Tax Subsidy Paid Parental Leave'))
281: 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'),Get_Element_Type_Id('Retro Wage Tax Subsidy Education')

Line 332: pay_run_results prr,

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

Line 348: and exists(select * from pay_run_results where assignment_action_id=asg_act.assignment_action_id and element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages'),Get_Element_Type_Id('Wage Tax Subsidy Education')

344: and ppa.date_earned between paa.effective_start_date and paa.effective_end_date
345: and prr.assignment_action_id=asg_act.assignment_action_id
346: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
347: and prr.element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages'),Get_Element_Type_Id('Wage Tax Subsidy Education'),Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed'),Get_Element_Type_Id('Wage Tax Subsidy Paid Parental Leave'))
348: and exists(select * from pay_run_results where assignment_action_id=asg_act.assignment_action_id and element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages'),Get_Element_Type_Id('Wage Tax Subsidy Education')
349: ,Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed'),Get_Element_Type_Id('Wage Tax Subsidy Paid Parental Leave')))
350: and (to_number(pay_nl_general.get_run_result_value(asg_act.assignment_action_id,prr.Element_Type_Id,
351: decode(prr.element_type_id,Get_Element_Type_Id('Wage Tax Subsidy Low Wages'),Get_Input_Value_Id('Wage Limit',Get_Element_Type_Id('Wage Tax Subsidy Low Wages')),Get_Element_Type_Id('Wage Tax Subsidy Education')
352: ,Get_Input_Value_Id('Wage Limit',Get_Element_Type_Id('Wage Tax Subsidy Education')),Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed'),Get_Input_Value_Id('Wage Limit',Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed'))

Line 398: pay_run_results prr,

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

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

413: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
414: and prr.element_type_id in (Get_Element_Type_Id('Retro Wage Tax Subsidy Low Wages'),
415: Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed'),Get_Element_Type_Id('Retro Wage Tax Subsidy Education')
416: ,Get_Element_Type_Id('Retro Wage Tax Subsidy Paid Parental Leave'))
417: and exists(select * from pay_run_results where assignment_action_id=asg_act.assignment_action_id and element_type_id
418: in (Get_Element_Type_Id('Retro Wage Tax Subsidy Low Wages'),Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed')
419: ,Get_Element_Type_Id('Retro Wage Tax Subsidy Education'),Get_Element_Type_Id('Retro Wage Tax Subsidy Paid Parental Leave')) )
420: order by employee_name, RDate , Sequence;
421: v_csr_get_record_details csr_get_record_details%ROWTYPE;

Line 811: from pay_run_results

807: and hoi.org_information3 IS NOT NULL
808: and hoi.org_information4 IS NOT NULL
809: and hoi.org_information_context='NL_ORG_INFORMATION'
810: and exists(select *
811: from pay_run_results
812: where assignment_action_id=asg_act.assignment_action_id
813: and (element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages')
814: ,Get_Element_Type_Id('Wage Tax Subsidy Education')
815: ,Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed')

Line 888: pay_run_results prr,

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

Line 912: from pay_run_results

908: ,Get_Element_Type_Id('Wage Tax Subsidy EVC')
909: --RSS
910: )
911: and exists(select *
912: from pay_run_results
913: where assignment_action_id=asg_act.assignment_action_id
914: and element_type_id in (Get_Element_Type_Id('Wage Tax Subsidy Low Wages')
915: ,Get_Element_Type_Id('Wage Tax Subsidy Education')
916: ,Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed')

Line 989: pay_run_results prr,

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

Line 1014: from pay_run_results

1010: Get_Element_Type_Id('Retro Wage Tax Subsidy EVC')
1011: --RSS
1012: )
1013: and exists(select *
1014: from pay_run_results
1015: where assignment_action_id=asg_act.assignment_action_id
1016: and element_type_id
1017: in (Get_Element_Type_Id('Retro Wage Tax Subsidy Low Wages'),
1018: Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed'),