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_TYPES

Line 624: pay_balance_types pbt

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
628: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1269: pay_balance_types b,

1265: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
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

Line 1643: pay_balance_types b,

1639: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
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

Line 2073: pay_balance_types pbt

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
2077: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2532: pay_balance_types pbt

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
2536: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2799: pay_balance_types pbt

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
2803: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 3334: , pay_balance_types b

3330: cursor get_defined_balance_id
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

Line 3686: pay_balance_types b,

3682: d.database_item_suffix database_item_suffix,
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'