APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on PAY_DEFINED_BALANCES

Line 34: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

30: , p_balance_name VARCHAR2
31: , p_balance_dim VARCHAR2
32: , p_virtual_date DATE) RETURN NUMBER IS
33:
34: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
35: l_value NUMBER;
36:
37:
38: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS

Line 40: FROM pay_defined_balances pdb

36:
37:
38: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
39: SELECT pdb.defined_balance_id
40: FROM pay_defined_balances pdb
41: ,pay_balance_types pbt
42: ,pay_balance_dimensions pbd
43: WHERE pbt.legislation_code='DK'
44: AND pbt.balance_name = p_balance_name