APPS.PAY_IP_UTILITY dependencies on PAY_BALANCE_TYPES

Line 89: lv_balance_name pay_balance_types.balance_name%TYPE;

85: -- ---------------------------------------------------------------------
86:
87: FUNCTION get_balance_name (p_balance_type_id IN NUMBER)
88: RETURN VARCHAR2 is
89: lv_balance_name pay_balance_types.balance_name%TYPE;
90: BEGIN
91:
92: SELECT balance_name
93: INTO lv_balance_name

Line 94: FROM pay_balance_types

90: BEGIN
91:
92: SELECT balance_name
93: INTO lv_balance_name
94: FROM pay_balance_types
95: WHERE balance_type_id = p_balance_type_id;
96:
97: RETURN lv_balance_name;
98: EXCEPTION

Line 1307: FROM pay_balance_types

1303:
1304: CURSOR get_balance_type_csr IS
1305: SELECT balance_type_id,
1306: balance_name
1307: FROM pay_balance_types
1308: WHERE legislation_code = 'ZZ';
1309:
1310: BEGIN
1311: hr_utility.set_location('pay_ip_utility.ins_bal_type_ownership',10);

Line 1359: ,pay_balance_types pbt

1355: SELECT pdb.defined_balance_id,
1356: replace(upper(pbt.balance_name),' ','_') || pbd.database_item_suffix def_bal_name
1357: FROM pay_defined_balances pdb
1358: ,pay_balance_dimensions pbd
1359: ,pay_balance_types pbt
1360: WHERE pdb.legislation_code = 'ZZ'
1361: AND pdb.balance_type_id = pbt.balance_type_id
1362: AND pdb.legislation_code = pbt.legislation_code
1363: AND pdb.balance_dimension_id = pbd.balance_dimension_id