APPS.PAY_CA_YEER_PKG dependencies on PAY_BALANCE_TYPES

Line 463: from pay_balance_types bal, pay_balance_types_tl tl

459:
460: select replace(replace(replace(replace(tl.balance_name,'T4A'),
461: 'T4'), 'RL1' ), '_' )
462: into l_bal_name
463: from pay_balance_types bal, pay_balance_types_tl tl
464: where upper(bal.balance_name) = upper(cp_bal_name)
465: and tl.balance_type_id = bal.balance_type_id
466: and tl.language = userenv('LANG');
467: