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 566: pay_balance_types pbt

562: cp_balance_dimension in varchar2 ) is
563: select pdb.defined_balance_id
564: from pay_defined_balances pdb,
565: pay_balance_dimensions pbd,
566: pay_balance_types pbt
567: where pbt.balance_name = cp_balance_name
568: and pbd.database_item_suffix= cp_balance_dimension
569: and pbt.balance_type_id = pdb.balance_type_id
570: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1064: from pay_balance_types

1060: where ppa.payroll_action_id = cp_payroll_action_id;
1061:
1062: cursor c_get_balance_type_id (cp_balance_name in varchar2) is
1063: select balance_type_id
1064: from pay_balance_types
1065: where balance_name = cp_balance_name
1066: and legislation_code = 'US';
1067:
1068: cursor c_get_balances (cp_action_context in varchar2) is

Line 1071: pay_balance_types pbt,

1067:
1068: cursor c_get_balances (cp_action_context in varchar2) is
1069: select fdu.form_left_prompt, pbt.balance_type_id
1070: from fnd_descr_flex_col_usage_tl fdu,
1071: pay_balance_types pbt,
1072: fnd_application fa
1073: where fdu.descriptive_flexfield_name = 'Action Information DF'
1074: and fdu.language = 'US'
1075: and pbt.balance_name = fdu.form_left_prompt

Line 1087: pay_balance_types pbt,

1083:
1084: cursor c_get_psd_balances (cp_action_context in varchar2) is
1085: select fdu.form_left_prompt, pbt.balance_type_id
1086: from fnd_descr_flex_col_usage_tl fdu,
1087: pay_balance_types pbt,
1088: fnd_application fa
1089: where fdu.descriptive_flexfield_name = 'Action Information DF'
1090: and fdu.language = 'US'
1091: and pbt.balance_name = substr(fdu.form_left_prompt,