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_US_ACTION_ARCH dependencies on PAY_BALANCE_TYPES

Line 467: pay_balance_types pbt

463: cp_balance_dimension in varchar2 ) is
464: select pdb.defined_balance_id
465: from pay_defined_balances pdb,
466: pay_balance_dimensions pbd,
467: pay_balance_types pbt
468: where pbt.balance_name = cp_balance_name
469: and pbd.database_item_suffix= cp_balance_dimension
470: and pbt.balance_type_id = pdb.balance_type_id
471: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 959: from pay_balance_types

955: where ppa.payroll_action_id = cp_payroll_action_id;
956:
957: cursor c_get_balance_type_id (cp_balance_name in varchar2) is
958: select balance_type_id
959: from pay_balance_types
960: where balance_name = cp_balance_name
961: and legislation_code = 'US';
962:
963: cursor c_get_balances (cp_action_context in varchar2) is

Line 966: pay_balance_types pbt,

962:
963: cursor c_get_balances (cp_action_context in varchar2) is
964: select fdu.form_left_prompt, pbt.balance_type_id
965: from fnd_descr_flex_col_usage_tl fdu,
966: pay_balance_types pbt,
967: fnd_application fa
968: where fdu.descriptive_flexfield_name = 'Action Information DF'
969: and fdu.language = 'US'
970: and pbt.balance_name = fdu.form_left_prompt