APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_RUN_RESULTS

Line 2293: ,pay_run_results adj_prr

2289: -- ,pay_payroll_actions bact
2290: ,pay_assignment_actions assact
2291: -- ,pay_payroll_actions pact
2292: ,pay_element_types_f adj_petf
2293: ,pay_run_results adj_prr
2294: WHERE bal_assact.assignment_action_id = c_ass_act_id -- assignment_action_id
2295: --and bal_assact.payroll_action_id = bact.payroll_action_id
2296: --and assact.payroll_action_id = pact.payroll_action_id
2297: --and pact.time_period_id = bact.time_period_id

Line 4326: ,pay_run_results prr

4322: AND asl.business_group_id = ppa.business_group_id
4323: AND ppa.business_group_id = c_business_group_id
4324: AND (EXISTS (SELECT 1
4325: FROM pay_assignment_actions paa1
4326: ,pay_run_results prr
4327: WHERE paa1.source_action_id = paa.assignment_action_id
4328: AND prr.assignment_action_id = paa1.assignment_action_id))
4329: UNION
4330: SELECT asl.assignment_id assignment_id

Line 4460: ,pay_run_results prr

4456: AND asl.business_group_id = ppa.business_group_id
4457: AND ppa.business_group_id = c_business_group_id
4458: AND (EXISTS (SELECT 1
4459: FROM pay_assignment_actions paa1
4460: ,pay_run_results prr
4461: WHERE paa1.source_action_id = paa.assignment_action_id
4462: AND prr.assignment_action_id = paa1.assignment_action_id))
4463: UNION
4464: SELECT asl.assignment_id assignment_id

Line 6020: FROM pay_run_results prr

6016: SELECT prr.rowid row_id
6017: ,prr.element_entry_id
6018: ,min(decode(piv.name, 'Report Type', rrv.RESULT_VALUE, null)) Retro_type
6019: ,min(decode(piv.name, 'Period', rrv.RESULT_VALUE, null)) Period
6020: FROM pay_run_results prr
6021: ,pay_run_result_values rrv
6022: ,pay_input_values_f piv
6023: ,pay_element_types_f pet
6024: WHERE prr.run_result_id = rrv.run_result_id

Line 6041: FROM pay_run_results prr

6037: CURSOR csr_get_retro_periods(c_assignment_action_id NUMBER
6038: ,c_date DATE) IS
6039: SELECT DISTINCT ptp.start_date start_date
6040: ,ptp.end_date end_date
6041: FROM pay_run_results prr
6042: ,pay_element_entries_f pee
6043: ,pay_assignment_actions paa
6044: ,pay_payroll_actions ppa
6045: ,per_time_periods ptp

Line 6062: FROM pay_run_results rr1 -- Retro element

6058: ,c_assignment_id NUMBER
6059: ,c_effective_date DATE) IS
6060: SELECT rr1.start_date , rc.short_name,rr1.element_entry_id
6061: ,rr1.end_date
6062: FROM pay_run_results rr1 -- Retro element
6063: ,pay_run_results rr2 -- Normal Element
6064: ,pay_element_span_usages esu
6065: ,pay_retro_component_usages rcu
6066: ,pay_retro_components rc

Line 6063: ,pay_run_results rr2 -- Normal Element

6059: ,c_effective_date DATE) IS
6060: SELECT rr1.start_date , rc.short_name,rr1.element_entry_id
6061: ,rr1.end_date
6062: FROM pay_run_results rr1 -- Retro element
6063: ,pay_run_results rr2 -- Normal Element
6064: ,pay_element_span_usages esu
6065: ,pay_retro_component_usages rcu
6066: ,pay_retro_components rc
6067: ,pay_element_entries_f pee1

Line 6095: FROM pay_run_results rr1 -- Retro element

6091: CURSOR csr_get_corr_retro_periods(c_assignment_action_id NUMBER
6092: ,c_effective_date DATE) IS
6093: SELECT DISTINCT ptp.start_date
6094: ,ptp.end_date
6095: FROM pay_run_results rr1 -- Retro element
6096: ,pay_element_span_usages esu
6097: ,pay_retro_component_usages rcu
6098: ,pay_retro_components rc
6099: ,pay_element_entries_f pee1

Line 6121: FROM pay_run_results rr

6117: ORDER BY 1;
6118:
6119: /*SELECT rr.start_date
6120: ,rr.end_date
6121: FROM pay_run_results rr
6122: ,pay_element_span_usages esu
6123: ,pay_retro_component_usages rcu
6124: ,pay_retro_components rc
6125: WHERE rr.assignment_action_id = c_assignment_action_id