APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_BALANCE_TYPES

Line 1729: pay_balance_types pbt,

1725: AND etei.information_type = 'AU_RETRO_UPGRADE_INFO')
1726: AND NOT EXISTS
1727: ( SELECT '1'
1728: FROM pay_balance_feeds_f pbf,
1729: pay_balance_types pbt,
1730: pay_input_values_f pivf
1731: WHERE pbt.balance_type_id = pbf.balance_type_id
1732: AND pbt.balance_name in ('Retro LT 12 Mths Curr Yr Amount',
1733: 'Retro LT 12 Mths Prev Yr Amount',

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

2036: and prc.retro_component_id = prcu.retro_component_id
2037: AND prcu.creator_id = p_element_type_id
2038: order by prcu.creator_id;
2039:
2040: CURSOR c_get_balance_type_id(c_name pay_balance_types.balance_name%type)
2041: IS
2042: SELECT balance_type_id
2043: FROM pay_balance_types
2044: WHERE legislation_code = 'AU'

Line 2043: FROM pay_balance_types

2039:
2040: CURSOR c_get_balance_type_id(c_name pay_balance_types.balance_name%type)
2041: IS
2042: SELECT balance_type_id
2043: FROM pay_balance_types
2044: WHERE legislation_code = 'AU'
2045: AND balance_name = c_name;
2046:
2047: /* Gets the name of the attached retro element */