eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_FPS_NI_AND_OTHERS dependencies on PAY_BALANCE_TYPES

Line 166: pay_balance_types b,

162: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
163: IS
164: SELECT defined_balance_id
165: FROM pay_defined_balances db,
166: pay_balance_types b,
167: pay_balance_dimensions d
168: WHERE b.balance_name = p_balance_name
169: AND d.dimension_name = p_dimension_name
170: AND db.balance_type_id = b.balance_type_id

Line 575: pay_balance_types b,

571: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
572: IS
573: SELECT defined_balance_id
574: FROM pay_defined_balances db,
575: pay_balance_types b,
576: pay_balance_dimensions d
577: WHERE b.balance_name = p_balance_name
578: AND d.dimension_name = p_dimension_name
579: AND db.balance_type_id = b.balance_type_id

Line 1061: pay_balance_types pbt

1057: IS
1058: SELECT pdb.defined_balance_id
1059: FROM pay_defined_balances pdb,
1060: pay_balance_dimensions pbd,
1061: pay_balance_types pbt
1062: WHERE pbt.balance_name = c_balance_name
1063: AND pbd.database_item_suffix = c_dim_name
1064: AND pbt.balance_type_id = pdb.balance_type_id
1065: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1385: pay_balance_types pbt

1381: IS
1382: SELECT pdb.defined_balance_id
1383: FROM pay_defined_balances pdb,
1384: pay_balance_dimensions pbd,
1385: pay_balance_types pbt
1386: WHERE pbt.balance_name = c_balance_name
1387: AND pbd.database_item_suffix = c_dim_name
1388: AND pbt.balance_type_id = pdb.balance_type_id
1389: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1717: pay_balance_types pbt

1713: IS
1714: SELECT pdb.defined_balance_id
1715: FROM pay_defined_balances pdb,
1716: pay_balance_dimensions pbd,
1717: pay_balance_types pbt
1718: WHERE pbt.balance_name = c_balance_name
1719: AND pbd.database_item_suffix = c_dim_name
1720: AND pbt.balance_type_id = pdb.balance_type_id
1721: AND pbd.balance_dimension_id = pdb.balance_dimension_id

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

2191:
2192: hr_utility.trace('f_asg_act_id :' || f_asg_act_id);
2193: hr_utility.trace('f_balance_name : '|| f_balance_name);
2194:
2195: select balance_type_id into l_bal_type_id from pay_balance_types where balance_name = f_balance_name
2196: and legislation_code = 'GB';
2197:
2198: hr_utility.trace('l_bal_type_id :' || l_bal_type_id);
2199:

Line 2376: pay_balance_types pbt

2372: IS
2373: SELECT pdb.defined_balance_id
2374: FROM pay_defined_balances pdb,
2375: pay_balance_dimensions pbd,
2376: pay_balance_types pbt
2377: WHERE pbt.balance_name = c_balance_name
2378: AND pbd.database_item_suffix = c_dim_name
2379: AND pbt.balance_type_id = pdb.balance_type_id
2380: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2654: pay_balance_types pbt

2650: IS
2651: SELECT pdb.defined_balance_id
2652: FROM pay_defined_balances pdb,
2653: pay_balance_dimensions pbd,
2654: pay_balance_types pbt
2655: WHERE pbt.balance_name = c_balance_name
2656: AND pbd.database_item_suffix = c_dim_name
2657: AND pbt.balance_type_id = pdb.balance_type_id
2658: AND pbd.balance_dimension_id = pdb.balance_dimension_id