APPS.PAY_DK_ARCHIVE_EIN dependencies on PAY_DEFINED_BALANCES

Line 25: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

21: ,p_balance_name IN VARCHAR2
22: ,p_balance_dim IN VARCHAR2
23: ,p_virtual_date IN DATE) RETURN NUMBER IS
24:
25: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
26: l_value NUMBER;
27:
28:
29: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS

Line 31: FROM pay_defined_balances pdb

27:
28:
29: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
30: SELECT pdb.defined_balance_id
31: FROM pay_defined_balances pdb
32: ,pay_balance_types pbt
33: ,pay_balance_dimensions pbd
34: WHERE pbt.legislation_code='DK'
35: AND pbt.balance_name = p_balance_name