APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PAY_BALANCE_TYPES

Line 560: FROM pay_balance_types pbt , pay_balance_categories_f pbc

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