DBA Data[Home] [Help]

APPS.PAY_EEI_BUS dependencies on PAY_RETRO_COMPONENT_USAGES

Line 1069: from pay_element_span_usages pesu, pay_retro_component_usages prcu

1065: where petei.element_type_id <> p_element_type_id
1066: and information_type = p_information_type
1067: and upper(eei_information2) = upper(p_element_code)
1068: and petei.element_type_id not in ((select prcu.creator_id
1069: from pay_element_span_usages pesu, pay_retro_component_usages prcu
1070: where pesu.retro_element_type_id = p_element_type_id
1071: and pesu.retro_component_usage_id = prcu.retro_component_usage_id
1072: and prcu.creator_type = 'ET')
1073: union

Line 1075: from pay_element_span_usages pesu, pay_retro_component_usages prcu

1071: and pesu.retro_component_usage_id = prcu.retro_component_usage_id
1072: and prcu.creator_type = 'ET')
1073: union
1074: (select pesu.retro_element_type_id
1075: from pay_element_span_usages pesu, pay_retro_component_usages prcu
1076: where prcu.creator_id = p_element_type_id
1077: and pesu.retro_component_usage_id = prcu.retro_component_usage_id
1078: and prcu.creator_type = 'ET'))
1079: and pet.element_type_id=petei.element_type_id