APPS.PAY_FI_ARCHIVE_DPSA dependencies on PAY_BALANCE_TYPES

Line 798: FROM pay_balance_types pbt , pay_balance_categories_f pbc

794: (p_balance_category_name VARCHAR2
795: ,p_business_group_id NUMBER)
796: IS
797: SELECT REPLACE(UPPER(pbt.balance_name),' ' ,'_') balance_name
798: FROM pay_balance_types pbt , pay_balance_categories_f pbc
799: WHERE pbc.legislation_code='FI'
800: AND pbt.business_group_id =p_business_group_id
801: AND pbt.balance_category_id = pbc.balance_category_id
802: AND pbc.category_name = p_balance_category_name ;