APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_BALANCE_TYPES

Line 1526: pay_balance_types pbt,

1522: AND etei.information_type = 'AU_RETRO_UPGRADE_INFO')
1523: AND NOT EXISTS
1524: ( SELECT '1'
1525: FROM pay_balance_feeds_f pbf,
1526: pay_balance_types pbt,
1527: pay_input_values_f pivf
1528: WHERE pbt.balance_type_id = pbf.balance_type_id
1529: AND pbt.balance_name in ('Retro LT 12 Mths Curr Yr Amount',
1530: 'Retro LT 12 Mths Prev Yr Amount',

Line 1837: CURSOR c_get_balance_type_id(c_name pay_balance_types.balance_name%type)

1833: and prc.retro_component_id = prcu.retro_component_id
1834: AND prcu.creator_id = p_element_type_id
1835: order by prcu.creator_id;
1836:
1837: CURSOR c_get_balance_type_id(c_name pay_balance_types.balance_name%type)
1838: IS
1839: SELECT balance_type_id
1840: FROM pay_balance_types
1841: WHERE legislation_code = 'AU'

Line 1840: FROM pay_balance_types

1836:
1837: CURSOR c_get_balance_type_id(c_name pay_balance_types.balance_name%type)
1838: IS
1839: SELECT balance_type_id
1840: FROM pay_balance_types
1841: WHERE legislation_code = 'AU'
1842: AND balance_name = c_name;
1843:
1844: /* Gets the name of the attached retro element */