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_WAGE_REPORT_PKG dependencies on PAY_RUN_RESULTS

Line 3462: ,pay_run_results adj_prr

3458: -- ,pay_payroll_actions bact
3459: ,pay_assignment_actions assact
3460: -- ,pay_payroll_actions pact
3461: ,pay_element_types_f adj_petf
3462: ,pay_run_results adj_prr
3463: WHERE bal_assact.assignment_action_id = c_ass_act_id -- assignment_action_id
3464: --and bal_assact.payroll_action_id = bact.payroll_action_id
3465: --and assact.payroll_action_id = pact.payroll_action_id
3466: --and pact.time_period_id = bact.time_period_id

Line 7214: ,pay_run_results prr

7210: AND asl.business_group_id = ppa.business_group_id
7211: AND ppa.business_group_id = c_business_group_id
7212: AND (EXISTS (SELECT 1
7213: FROM pay_assignment_actions paa1
7214: ,pay_run_results prr
7215: WHERE paa1.source_action_id = paa.assignment_action_id
7216: AND prr.assignment_action_id = paa1.assignment_action_id))
7217: UNION
7218: SELECT asl.assignment_id assignment_id

Line 7348: ,pay_run_results prr

7344: AND asl.business_group_id = ppa.business_group_id
7345: AND ppa.business_group_id = c_business_group_id
7346: AND (EXISTS (SELECT 1
7347: FROM pay_assignment_actions paa1
7348: ,pay_run_results prr
7349: WHERE paa1.source_action_id = paa.assignment_action_id
7350: AND prr.assignment_action_id = paa1.assignment_action_id))
7351: UNION
7352: SELECT asl.assignment_id assignment_id

Line 7416: ,pay_run_results prr

7412: AND asl.business_group_id = ppa.business_group_id
7413: AND ppa.business_group_id = c_business_group_id
7414: AND (EXISTS (SELECT 1
7415: FROM pay_assignment_actions paa1
7416: ,pay_run_results prr
7417: WHERE paa1.source_action_id = paa.assignment_action_id
7418: AND prr.assignment_action_id = paa1.assignment_action_id))
7419: AND EXISTS
7420: --10100628

Line 7431: FROM pay_run_results rr1 -- Retro element

7427: AND nvl(fnd_date.canonical_to_date(aei_information2),to_date('31-12-4712','dd-mm-yyyy'))
7428: )
7429: --10100628
7430: /* ( SELECT 1
7431: FROM pay_run_results rr1 -- Retro element
7432: ,pay_element_span_usages esu
7433: ,pay_retro_component_usages rcu
7434: ,pay_retro_components rc
7435: ,pay_element_entries_f pee1

Line 9688: FROM pay_run_results prr

9684: SELECT prr.rowid row_id
9685: ,prr.element_entry_id
9686: ,min(decode(piv.name, 'Report Type', rrv.RESULT_VALUE, null)) Retro_type
9687: ,min(decode(piv.name, 'Period', rrv.RESULT_VALUE, null)) Period
9688: FROM pay_run_results prr
9689: ,pay_run_result_values rrv
9690: ,pay_input_values_f piv
9691: ,pay_element_types_f pet
9692: WHERE prr.run_result_id = rrv.run_result_id

Line 9709: FROM pay_run_results prr

9705: CURSOR csr_get_retro_periods(c_assignment_action_id NUMBER
9706: ,c_date DATE) IS
9707: SELECT DISTINCT ptp.start_date start_date
9708: ,ptp.end_date end_date
9709: FROM pay_run_results prr
9710: ,pay_element_entries_f pee
9711: ,pay_assignment_actions paa
9712: ,pay_payroll_actions ppa
9713: ,per_time_periods ptp

Line 9730: FROM pay_run_results rr1 -- Retro element

9726: ,c_assignment_id NUMBER
9727: ,c_effective_date DATE) IS
9728: SELECT rr1.start_date , rc.short_name,rr1.element_entry_id
9729: ,rr1.end_date
9730: FROM pay_run_results rr1 -- Retro element
9731: ,pay_run_results rr2 -- Normal Element
9732: ,pay_element_span_usages esu
9733: ,pay_retro_component_usages rcu
9734: ,pay_retro_components rc

Line 9731: ,pay_run_results rr2 -- Normal Element

9727: ,c_effective_date DATE) IS
9728: SELECT rr1.start_date , rc.short_name,rr1.element_entry_id
9729: ,rr1.end_date
9730: FROM pay_run_results rr1 -- Retro element
9731: ,pay_run_results rr2 -- Normal Element
9732: ,pay_element_span_usages esu
9733: ,pay_retro_component_usages rcu
9734: ,pay_retro_components rc
9735: ,pay_element_entries_f pee1

Line 9763: FROM pay_run_results rr1 -- Retro element

9759: CURSOR csr_get_corr_retro_periods(c_assignment_action_id NUMBER
9760: ,c_effective_date DATE) IS
9761: SELECT DISTINCT ptp.start_date
9762: ,ptp.end_date
9763: FROM pay_run_results rr1 -- Retro element
9764: ,pay_element_span_usages esu
9765: ,pay_retro_component_usages rcu
9766: ,pay_retro_components rc
9767: ,pay_element_entries_f pee1

Line 9789: FROM pay_run_results rr

9785: ORDER BY 1;
9786:
9787: /*SELECT rr.start_date
9788: ,rr.end_date
9789: FROM pay_run_results rr
9790: ,pay_element_span_usages esu
9791: ,pay_retro_component_usages rcu
9792: ,pay_retro_components rc
9793: WHERE rr.assignment_action_id = c_assignment_action_id

Line 9963: ,pay_run_results prr

9959: SELECT prrv.result_value
9960: FROM pay_run_result_values prrv
9961: ,pay_input_values_f piv
9962: ,pay_element_types_f pet
9963: ,pay_run_results prr
9964: WHERE pet.element_name = 'Small Job Indicator'
9965: AND pet.element_type_id = piv.element_type_id
9966: AND piv.name = 'Exempt Small Jobs'
9967: AND pet.legislation_code = 'NL'

Line 14162: ,pay_run_results prr

14158: SELECT prrv.result_value
14159: FROM pay_run_result_values prrv
14160: ,pay_input_values_f piv
14161: ,pay_element_types_f pet
14162: ,pay_run_results prr
14163: WHERE pet.element_name = 'Small Job Indicator'
14164: AND pet.element_type_id = piv.element_type_id
14165: AND piv.name = 'Exempt Small Jobs'
14166: AND pet.legislation_code = 'NL'

Line 14710: FROM pay_run_results rr1 -- Retro element

14706: )
14707: --10100628
14708: /*
14709: ( SELECT 1
14710: FROM pay_run_results rr1 -- Retro element
14711: ,pay_element_span_usages esu
14712: ,pay_retro_component_usages rcu
14713: ,pay_retro_components rc
14714: ,pay_element_entries_f pee1

Line 14745: FROM pay_run_results rr1

14741: ,c_effective_date DATE)
14742: IS
14743: SELECT DISTINCT ptp.start_date
14744: ,ptp.end_date
14745: FROM pay_run_results rr1
14746: ,pay_element_span_usages esu
14747: ,pay_retro_component_usages rcu
14748: ,pay_retro_components rc
14749: ,pay_element_entries_f pee1