DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_ELEMENT_SPAN_USAGES

Line 6064: ,pay_element_span_usages esu

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
6068: ,pay_element_entries_f pee2

Line 6096: ,pay_element_span_usages esu

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
6100: ,pay_assignment_actions paa

Line 6122: ,pay_element_span_usages esu

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
6126: AND rr.element_type_id = esu.retro_element_type_id