APPS.PAY_SE_ARCHIVE_CWCA dependencies on PAY_BALANCE_CATEGORIES_F

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 ;