DBA Data[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_RETRO_COMPONENTS

Line 166: FROM pay_retro_components

162: WHERE prcu.retro_component_usage_id = pesu.retro_component_usage_id
163: AND retro_component_id =
164: (
165: SELECT retro_component_id
166: FROM pay_retro_components
167: WHERE legislation_code = 'NL'
168: AND short_name = 'Adjustment'
169: AND component_name = 'Adjustment'
170: )

Line 231: FROM pay_retro_components

227: FROM pay_element_span_usages pesu,
228: pay_retro_component_usages prcu
229: WHERE prcu.retro_component_usage_id = pesu.retro_component_usage_id
230: AND retro_component_id = ( SELECT retro_component_id
231: FROM pay_retro_components
232: WHERE legislation_code = 'NL'
233: AND short_name = 'Adjustment'
234: AND component_name = 'Adjustment')
235: AND creator_type = 'ET'