APPS.PAY_CA_GROUP_LEVEL_BAL_PKG dependencies on PAY_BALANCE_TYPES

Line 208: FROM pay_balance_types blt

204: p_bus_grp_id NUMBER) IS
205: SELECT dbl.defined_balance_id
206: FROM pay_defined_balances dbl
207: WHERE dbl.balance_type_id = (SELECT balance_type_id
208: FROM pay_balance_types blt
209: WHERE blt.balance_name = p_bal_name
210: AND (blt.legislation_code = 'CA'
211: OR blt.business_group_id = p_bus_grp_id))
212: AND dbl.balance_dimension_id =(SELECT balance_dimension_id