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 788: FROM pay_retro_components

784: FROM pay_element_span_usages pesu,
785: pay_retro_component_usages prcu
786: WHERE prcu.retro_component_usage_id = pesu.retro_component_usage_id
787: AND retro_component_id = ( SELECT retro_component_id
788: FROM pay_retro_components
789: WHERE legislation_code = 'NL'
790: AND short_name = 'Adjustment'
791: AND component_name = 'Adjustment')
792: AND creator_type = 'ET'