DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_RETRO_COMPONENTS

Line 371: FROM pay_retro_components

367: FROM pay_element_span_usages pesu,
368: pay_retro_component_usages prcu
369: WHERE prcu.retro_component_usage_id = pesu.retro_component_usage_id
370: AND retro_component_id = ( SELECT retro_component_id
371: FROM pay_retro_components
372: WHERE legislation_code = 'NL'
373: AND short_name = 'Adjustment'
374: AND component_name = 'Adjustment')
375: AND creator_type = 'ET'

Line 769: FROM pay_retro_components

765: FROM pay_element_span_usages pesu,
766: pay_retro_component_usages prcu
767: WHERE prcu.retro_component_usage_id = pesu.retro_component_usage_id
768: AND retro_component_id = ( SELECT retro_component_id
769: FROM pay_retro_components
770: WHERE legislation_code = 'NL'
771: AND short_name = 'Adjustment'
772: AND component_name = 'Adjustment')
773: AND creator_type = 'ET'