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

Line 1123: from pay_balance_types pbt,

1119: -- for error reporting.
1120: select upper(replace(pbt.balance_name, ' ', '_')) ||
1121: pbd.database_item_suffix
1122: into l_balance_name
1123: from pay_balance_types pbt,
1124: pay_balance_dimensions pbd,
1125: pay_defined_balances pdb
1126: where pdb.defined_balance_id = c1rec.defined_balance_id
1127: and pbt.balance_type_id = pdb.balance_type_id

Line 1167: jur_lev pay_balance_types.jurisdiction_level%type

1163: type et_r is record
1164: (
1165: iv_count number,
1166: currency_code pay_element_types.input_currency_code%type,
1167: jur_lev pay_balance_types.jurisdiction_level%type
1168: );
1169:
1170: -- The table is indexed by element_link_id.
1171: type et_t is table of et_r index by binary_integer;

Line 1186: pay_balance_types pbt,

1182: pbt.currency_code,
1183: nvl(pbt.jurisdiction_level, 0) jurisdiction_level
1184: from pay_balance_set_members bsm,
1185: pay_defined_balances pdb,
1186: pay_balance_types pbt,
1187: pay_balance_dimensions pbd
1188: where bsm.balance_set_id = p_balance_set_id
1189: and pdb.defined_balance_id = bsm.defined_balance_id
1190: and pbt.balance_type_id = pdb.balance_type_id

Line 1205: pay_balance_types pbt,

1201: ff_formulas_f fff,
1202: ff_database_items fdi,
1203: ff_user_entities fue,
1204: pay_defined_balances pdb,
1205: pay_balance_types pbt,
1206: pay_balance_dimensions pbd
1207: where ((fff.business_group_id is null and fff.legislation_code is null)
1208: or (fff.business_group_id is null
1209: and fff.legislation_code = p_legislation_code)