DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_RETRO_COMPONENT_USAGES

Line 368: pay_retro_component_usages prcu

364: ,pei.eei_information18 cy_retro_element_id
365: ,pei.eei_information19 py_retro_element_id
366: ,(SELECT retro_element_type_id
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'

Line 766: pay_retro_component_usages prcu

762: OR to_number(pei.eei_information20) = pet.element_type_id
763: OR to_number(pei.eei_information21) = pet.element_type_id
764: OR pet.element_type_id IN (SELECT retro_element_type_id
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'