APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on PAY_BALANCE_TYPES

Line 133: pay_balance_types b,

129: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
130: IS
131: SELECT defined_balance_id
132: FROM pay_defined_balances db,
133: pay_balance_types b,
134: pay_balance_dimensions d
135: WHERE b.balance_name = p_balance_name
136: AND d.dimension_name = p_dimension_name
137: AND db.balance_type_id = b.balance_type_id

Line 542: pay_balance_types b,

538: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
539: IS
540: SELECT defined_balance_id
541: FROM pay_defined_balances db,
542: pay_balance_types b,
543: pay_balance_dimensions d
544: WHERE b.balance_name = p_balance_name
545: AND d.dimension_name = p_dimension_name
546: AND db.balance_type_id = b.balance_type_id

Line 1025: pay_balance_types pbt

1021: IS
1022: SELECT pdb.defined_balance_id
1023: FROM pay_defined_balances pdb,
1024: pay_balance_dimensions pbd,
1025: pay_balance_types pbt
1026: WHERE pbt.balance_name = c_balance_name
1027: AND pbd.database_item_suffix = c_dim_name
1028: AND pbt.balance_type_id = pdb.balance_type_id
1029: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1356: pay_balance_types pbt

1352: IS
1353: SELECT pdb.defined_balance_id
1354: FROM pay_defined_balances pdb,
1355: pay_balance_dimensions pbd,
1356: pay_balance_types pbt
1357: WHERE pbt.balance_name = c_balance_name
1358: AND pbd.database_item_suffix = c_dim_name
1359: AND pbt.balance_type_id = pdb.balance_type_id
1360: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1694: pay_balance_types pbt

1690: IS
1691: SELECT pdb.defined_balance_id
1692: FROM pay_defined_balances pdb,
1693: pay_balance_dimensions pbd,
1694: pay_balance_types pbt
1695: WHERE pbt.balance_name = c_balance_name
1696: AND pbd.database_item_suffix = c_dim_name
1697: AND pbt.balance_type_id = pdb.balance_type_id
1698: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2183: select balance_type_id into l_bal_type_id from pay_balance_types where balance_name = f_balance_name

2179:
2180: hr_utility.trace('f_asg_act_id :' || f_asg_act_id);
2181: hr_utility.trace('f_balance_name : '|| f_balance_name);
2182:
2183: select balance_type_id into l_bal_type_id from pay_balance_types where balance_name = f_balance_name
2184: and legislation_code = 'GB';
2185:
2186: hr_utility.trace('l_bal_type_id :' || l_bal_type_id);
2187:

Line 2364: pay_balance_types pbt

2360: IS
2361: SELECT pdb.defined_balance_id
2362: FROM pay_defined_balances pdb,
2363: pay_balance_dimensions pbd,
2364: pay_balance_types pbt
2365: WHERE pbt.balance_name = c_balance_name
2366: AND pbd.database_item_suffix = c_dim_name
2367: AND pbt.balance_type_id = pdb.balance_type_id
2368: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2649: pay_balance_types pbt

2645: IS
2646: SELECT pdb.defined_balance_id
2647: FROM pay_defined_balances pdb,
2648: pay_balance_dimensions pbd,
2649: pay_balance_types pbt
2650: WHERE pbt.balance_name = c_balance_name
2651: AND pbd.database_item_suffix = c_dim_name
2652: AND pbt.balance_type_id = pdb.balance_type_id
2653: AND pbd.balance_dimension_id = pdb.balance_dimension_id