DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_RETRO_COMPONENTS

Line 7434: ,pay_retro_components rc

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
7436: ,pay_assignment_actions paa1
7437: ,pay_payroll_actions ppa1
7438: ,per_time_periods ptp

Line 9734: ,pay_retro_components rc

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
9736: ,pay_element_entries_f pee2
9737: ,pay_retro_assignments pra
9738: ,pay_retro_entries pre

Line 9766: ,pay_retro_components rc

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
9768: ,pay_assignment_actions paa
9769: ,pay_payroll_actions ppa
9770: ,per_time_periods ptp

Line 9792: ,pay_retro_components rc

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
9794: AND rr.element_type_id = esu.retro_element_type_id
9795: AND esu.retro_component_usage_id = rcu.retro_component_usage_id
9796: AND rcu.retro_component_id = rc.retro_component_id

Line 14713: ,pay_retro_components rc

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
14715: ,pay_assignment_actions paa1
14716: ,pay_payroll_actions ppa1
14717: ,per_time_periods ptp

Line 14748: ,pay_retro_components rc

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
14750: ,pay_assignment_actions paa
14751: ,pay_payroll_actions ppa
14752: ,per_time_periods ptp