DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_RETRO_COMPONENTS

Line 6066: ,pay_retro_components rc

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
6068: ,pay_element_entries_f pee2
6069: ,pay_retro_assignments pra
6070: ,pay_retro_entries pre

Line 6098: ,pay_retro_components rc

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
6100: ,pay_assignment_actions paa
6101: ,pay_payroll_actions ppa
6102: ,per_time_periods ptp

Line 6124: ,pay_retro_components rc

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
6126: AND rr.element_type_id = esu.retro_element_type_id
6127: AND esu.retro_component_usage_id = rcu.retro_component_usage_id
6128: AND rcu.retro_component_id = rc.retro_component_id