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_TYPES

Line 4526: pay_balance_types pbt

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
4530: and pbd.balance_dimension_id = pdb.balance_dimension_id and

Line 5193: pay_balance_types pbt

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
5197: and pbd.balance_dimension_id = pdb.balance_dimension_id and

Line 6288: , pay_balance_types b

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

Line 7343: pay_balance_types b,

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

Line 7394: pay_balance_types b,

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

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 8619: , pay_balance_types b

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