APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

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

1359: null,null,null,null,null);
1360:
1361: END IF;
1362:
1363: /*An entry is created in the table pay_element_type_extra_info table. This
1364: table is used to identify whether a retro element is already created by the
1365: upgrade process. If so, for the given element no corresponding reto elements
1366: are created*/
1367:

Line 1618: from pay_element_type_extra_info

1614:
1615:
1616: CURSOR upgraded_element_check(cp_element_type_id pay_element_types_f.element_type_id%type) IS
1617: select 'Y'
1618: from pay_element_type_extra_info
1619: where element_type_id= cp_element_type_id
1620: and information_type='AU_RETRO_UPGRADE_INFO' ;
1621:
1622: l_element_type_id pay_element_types_f.element_type_id%type;

Line 1723: FROM pay_element_type_extra_info etei

1719: and pscr.classification_id = pec2.classification_id(+)
1720: and pec2.legislation_code (+)= 'AU'
1721: AND NOT EXISTS
1722: (SELECT '1'
1723: FROM pay_element_type_extra_info etei
1724: WHERE etei.element_type_id = pet.element_type_id
1725: AND etei.information_type = 'AU_RETRO_UPGRADE_INFO')
1726: AND NOT EXISTS
1727: ( SELECT '1'