APPS.PAY_SE_ARCHIVE_CWCA dependencies on PAY_BALANCE_TYPES

Line 283: FROM pay_balance_types pbt , pay_balance_categories_f pbc

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