DBA Data[Home] [Help]

APPS.PAY_CA_GROUP_LEVEL_BAL_PKG dependencies on PAY_DEFINED_BALANCES

Line 206: FROM pay_defined_balances dbl

202: CURSOR csr_get_def_bal_id(p_bal_name VARCHAR2,
203: p_dimension VARCHAR2,
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'