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_DIMENSIONS

Line 167: pay_balance_dimensions d

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
171: AND db.balance_dimension_id = d.balance_dimension_id;

Line 576: pay_balance_dimensions d

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
580: AND db.balance_dimension_id = d.balance_dimension_id;

Line 1060: pay_balance_dimensions pbd,

1056: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
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

Line 1384: pay_balance_dimensions pbd,

1380: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
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

Line 1716: pay_balance_dimensions pbd,

1712: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
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

Line 2375: pay_balance_dimensions pbd,

2371: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
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

Line 2653: pay_balance_dimensions pbd,

2649: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
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