APPS.PAY_DK_ARCHIVE_EIN dependencies on PAY_DEFINED_BALANCES

Line 35: pay_defined_balances pdb

31: IS
32: SELECT pdb.defined_balance_id
33: FROM pay_balance_dimensions pbd,
34: pay_balance_types pbt,
35: pay_defined_balances pdb
36: WHERE pbd.database_item_suffix = p_dimension_suffix
37: AND pbd.business_group_id IS NULL
38: AND pbd.legislation_code = 'DK'
39: AND pbt.balance_name = p_balance_name

Line 47: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

43: AND pdb.balance_dimension_id = pbd.balance_dimension_id
44: AND pdb.business_group_id IS NULL
45: AND pdb.legislation_code = 'DK';
46:
47: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
48: BEGIN
49: OPEN csr_defined_balance_id;
50: FETCH csr_defined_balance_id INTO l_defined_balance_id;
51: CLOSE csr_defined_balance_id;

Line 63: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

59: ,p_balance_name IN VARCHAR2
60: ,p_balance_dim IN VARCHAR2
61: ,p_virtual_date IN DATE) RETURN NUMBER IS
62:
63: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
64: l_value NUMBER;
65:
66:
67: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS

Line 69: FROM pay_defined_balances pdb

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