APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on PAY_DEFINED_BALANCES

Line 59: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

55: , p_balance_name VARCHAR2
56: , p_balance_dim VARCHAR2
57: , p_virtual_date DATE) RETURN NUMBER IS
58:
59: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
60: l_value NUMBER;
61:
62:
63: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS

Line 65: FROM pay_defined_balances pdb

61:
62:
63: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
64: SELECT pdb.defined_balance_id
65: FROM pay_defined_balances pdb
66: ,pay_balance_types pbt
67: ,pay_balance_dimensions pbd
68: WHERE pbt.legislation_code='DK'
69: AND pbt.balance_name = p_balance_name