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

Line 4525: pay_balance_dimensions pbd,

4521: and e1.element_link_id = link1.element_link_id);
4522:
4523: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
4524: select pdb.defined_balance_id from pay_defined_balances pdb,
4525: pay_balance_dimensions pbd,
4526: pay_balance_types pbt
4527: where pbt.balance_name = c_balance_name
4528: and pbd.database_item_suffix = c_dim_name
4529: and pbt.balance_type_id= pdb.balance_type_id

Line 5192: pay_balance_dimensions pbd,

5188:
5189:
5190: cursor csr_get_taxable_pay(c_balance_name varchar2, c_dim_name varchar2) is
5191: select pdb.defined_balance_id from pay_defined_balances pdb,
5192: pay_balance_dimensions pbd,
5193: pay_balance_types pbt
5194: where pbt.balance_name = c_balance_name
5195: and pbd.database_item_suffix = c_dim_name
5196: and pbt.balance_type_id= pdb.balance_type_id

Line 6289: , pay_balance_dimensions d

6285: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
6286: SELECT defined_balance_id
6287: FROM pay_defined_balances db
6288: , pay_balance_types b
6289: , pay_balance_dimensions d
6290: WHERE b.balance_name = p_balance_name
6291: AND d.dimension_name = p_dimension_name
6292: AND db.balance_type_id = b.balance_type_id
6293: AND db.balance_dimension_id = d.balance_dimension_id

Line 7344: pay_balance_dimensions d

7340: d.balance_dimension_id balance_dimension_id,
7341: db.defined_balance_id defined_balance_id
7342: FROM pay_defined_balances db,
7343: pay_balance_types b,
7344: pay_balance_dimensions d
7345: WHERE db.balance_type_id = b.balance_type_id
7346: AND db.balance_dimension_id = d.balance_dimension_id
7347: AND ((d.database_item_suffix = '_ASG_TD_YTD'
7348: AND b.balance_name IN ('Taxable Pay','PAYE','Student Loan','SSP Total',

Line 7395: pay_balance_dimensions d

7391: d.balance_dimension_id balance_dimension_id,
7392: db.defined_balance_id defined_balance_id
7393: FROM pay_defined_balances db,
7394: pay_balance_types b,
7395: pay_balance_dimensions d
7396: WHERE db.balance_type_id = b.balance_type_id
7397: AND db.balance_dimension_id = d.balance_dimension_id
7398: AND ((d.database_item_suffix = '_PER_TD_YTD'
7399: AND b.balance_name IN ('Taxable Pay','PAYE','Student Loan','SSP Total','SMP Total',

Line 7608: select pdb.defined_balance_id from pay_balance_types pbt, pay_balance_dimensions pbd,

7604: --
7605: procedure add_other_asg_ni_ytd(c_asg_act_id in number , p_archive_tab in out nocopy act_info_rec) is
7606:
7607: cursor csr_def_bal_id(c_bal_name varchar2, c_dim_name varchar2) is
7608: select pdb.defined_balance_id from pay_balance_types pbt, pay_balance_dimensions pbd,
7609: pay_defined_balances pdb where
7610: pbt.balance_name = c_bal_name
7611: and pbd.database_item_suffix = c_dim_name
7612: and pdb.balance_type_id = pbt.balance_type_id

Line 8620: , pay_balance_dimensions d

8616: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
8617: SELECT defined_balance_id
8618: FROM pay_defined_balances db
8619: , pay_balance_types b
8620: , pay_balance_dimensions d
8621: WHERE b.balance_name = p_balance_name
8622: AND d.dimension_name = p_dimension_name
8623: AND db.balance_type_id = b.balance_type_id
8624: AND db.balance_dimension_id = d.balance_dimension_id