APPS.PAY_DK_ARCHIVE_EHOL dependencies on PAY_DEFINED_BALANCES

Line 71: pay_defined_balances pdb

67: IS
68: SELECT pdb.defined_balance_id
69: FROM pay_balance_dimensions pbd,
70: pay_balance_types pbt,
71: pay_defined_balances pdb
72: WHERE pbd.database_item_suffix = p_dimension_suffix
73: AND pbd.business_group_id IS NULL
74: AND pbd.legislation_code = 'DK'
75: AND pbt.balance_name = p_balance_name

Line 83: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

79: AND pdb.balance_dimension_id = pbd.balance_dimension_id
80: AND pdb.business_group_id IS NULL
81: AND pdb.legislation_code = 'DK';
82:
83: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
84: BEGIN
85: OPEN csr_defined_balance_id;
86: FETCH csr_defined_balance_id INTO l_defined_balance_id;
87: CLOSE csr_defined_balance_id;

Line 99: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

95: ,p_balance_name IN VARCHAR2
96: ,p_balance_dim IN VARCHAR2
97: ,p_virtual_date IN DATE) RETURN NUMBER IS
98:
99: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
100: l_value NUMBER;
101:
102:
103: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS

Line 105: FROM pay_defined_balances pdb

101:
102:
103: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
104: SELECT pdb.defined_balance_id
105: FROM pay_defined_balances pdb
106: ,pay_balance_types pbt
107: ,pay_balance_dimensions pbd
108: WHERE pbt.legislation_code='DK'
109: AND pbt.balance_name = p_balance_name