APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PAY_BALANCE_TYPES

Line 558: FROM pay_balance_types pbt , pay_balance_categories_f pbc

554: (p_balance_category_name VARCHAR2
555: ,p_business_group_id NUMBER)
556: IS
557: SELECT REPLACE(UPPER(pbt.balance_name),' ' ,'_') balance_name , pbt.balance_name bname
558: FROM pay_balance_types pbt , pay_balance_categories_f pbc
559: WHERE pbc.legislation_code='SE'
560: AND pbt.business_group_id =p_business_group_id
561: AND pbt.balance_category_id = pbc.balance_category_id
562: AND pbc.category_name = p_balance_category_name ;