APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 1164: /*An entry is created in the table pay_element_type_extra_info table. This

1160: ,p_object_version_number => l_ovn
1161: ,p_comment_id => l_comment_id
1162: ,p_processing_priority_warning => l_warning);
1163:
1164: /*An entry is created in the table pay_element_type_extra_info table. This
1165: table is used to identify whether a retro element is already created by the
1166: upgrade process. If so, for the given element no corresponding reto elements
1167: are created*/
1168:

Line 1415: from pay_element_type_extra_info

1411:
1412:
1413: CURSOR upgraded_element_check(cp_element_type_id pay_element_types_f.element_type_id%type) IS
1414: select 'Y'
1415: from pay_element_type_extra_info
1416: where element_type_id= cp_element_type_id
1417: and information_type='AU_RETRO_UPGRADE_INFO' ;
1418:
1419: l_element_type_id pay_element_types_f.element_type_id%type;

Line 1520: FROM pay_element_type_extra_info etei

1516: and pscr.classification_id = pec2.classification_id(+)
1517: and pec2.legislation_code (+)= 'AU'
1518: AND NOT EXISTS
1519: (SELECT '1'
1520: FROM pay_element_type_extra_info etei
1521: WHERE etei.element_type_id = pet.element_type_id
1522: AND etei.information_type = 'AU_RETRO_UPGRADE_INFO')
1523: AND NOT EXISTS
1524: ( SELECT '1'