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_RTI_P60 dependencies on PAY_BALANCE_DIMENSIONS

Line 623: pay_balance_dimensions pbd,

619:
620: CURSOR csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
621: SELECT pdb.defined_balance_id
622: FROM pay_defined_balances pdb,
623: pay_balance_dimensions pbd,
624: pay_balance_types pbt
625: WHERE pbt.balance_name = c_balance_name
626: AND pbd.database_item_suffix = c_dim_name
627: AND pbt.balance_type_id= pdb.balance_type_id

Line 1270: pay_balance_dimensions d

1266: IS
1267: SELECT defined_balance_id
1268: FROM pay_defined_balances db,
1269: pay_balance_types b,
1270: pay_balance_dimensions d
1271: WHERE b.balance_name = p_balance_name
1272: AND d.dimension_name = p_dimension_name
1273: AND db.balance_type_id = b.balance_type_id
1274: AND db.balance_dimension_id = d.balance_dimension_id;

Line 1644: pay_balance_dimensions d

1640: IS
1641: SELECT defined_balance_id
1642: FROM pay_defined_balances db,
1643: pay_balance_types b,
1644: pay_balance_dimensions d
1645: WHERE b.balance_name = p_balance_name
1646: AND d.dimension_name = p_dimension_name
1647: AND db.balance_type_id = b.balance_type_id
1648: AND db.balance_dimension_id = d.balance_dimension_id;

Line 2072: pay_balance_dimensions pbd,

2068: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2069: IS
2070: SELECT pdb.defined_balance_id
2071: FROM pay_defined_balances pdb,
2072: pay_balance_dimensions pbd,
2073: pay_balance_types pbt
2074: WHERE pbt.balance_name = c_balance_name
2075: AND pbd.database_item_suffix = c_dim_name
2076: AND pbt.balance_type_id = pdb.balance_type_id

Line 2531: pay_balance_dimensions pbd,

2527: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2528: IS
2529: SELECT pdb.defined_balance_id
2530: FROM pay_defined_balances pdb,
2531: pay_balance_dimensions pbd,
2532: pay_balance_types pbt
2533: WHERE pbt.balance_name = c_balance_name
2534: AND pbd.database_item_suffix = c_dim_name
2535: AND pbt.balance_type_id = pdb.balance_type_id

Line 2798: pay_balance_dimensions pbd,

2794: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2795: IS
2796: SELECT pdb.defined_balance_id
2797: FROM pay_defined_balances pdb,
2798: pay_balance_dimensions pbd,
2799: pay_balance_types pbt
2800: WHERE pbt.balance_name = c_balance_name
2801: AND pbd.database_item_suffix = c_dim_name
2802: AND pbt.balance_type_id = pdb.balance_type_id

Line 3335: , pay_balance_dimensions d

3331: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
3332: SELECT defined_balance_id
3333: FROM pay_defined_balances db
3334: , pay_balance_types b
3335: , pay_balance_dimensions d
3336: WHERE b.balance_name = p_balance_name
3337: AND d.dimension_name = p_dimension_name
3338: AND db.balance_type_id = b.balance_type_id
3339: AND db.balance_dimension_id = d.balance_dimension_id

Line 3687: pay_balance_dimensions d

3683: d.balance_dimension_id balance_dimension_id,
3684: db.defined_balance_id defined_balance_id
3685: FROM pay_defined_balances db,
3686: pay_balance_types b,
3687: pay_balance_dimensions d
3688: WHERE db.balance_type_id = b.balance_type_id
3689: AND db.balance_dimension_id = d.balance_dimension_id
3690: AND ((d.database_item_suffix = '_ASG_TD_YTD'
3691: AND b.balance_name IN ('Taxable Pay', 'PAYE', 'Student Loan', 'SMP Total',