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

Line 286: FROM pay_balance_types pbt , pay_balance_categories_f pbc

282: (p_balance_category_name VARCHAR2
283: ,p_business_group_id NUMBER)
284: IS
285: SELECT REPLACE(UPPER(pbt.balance_name),' ' ,'_') balance_name , pbt.balance_name bname
286: FROM pay_balance_types pbt , pay_balance_categories_f pbc
287: WHERE pbc.legislation_code='SE'
288: AND pbt.business_group_id =p_business_group_id
289: AND pbt.balance_category_id = pbc.balance_category_id
290: AND pbc.category_name = p_balance_category_name ;

Line 1337: ,pay_balance_types pbt

1333:
1334: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
1335: SELECT pdb.defined_balance_id
1336: FROM pay_defined_balances pdb
1337: ,pay_balance_types pbt
1338: ,pay_balance_dimensions pbd
1339: WHERE pbt.legislation_code='SE'
1340: AND pbt.balance_name = p_balance_name
1341: AND pbd.legislation_code = 'SE'