APPS.PAY_DK_STATSR_PKG dependencies on PAY_DEFINED_BALANCES

Line 175: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

171: ,p_balance_name IN VARCHAR2
172: ,p_balance_dim IN VARCHAR2
173: ,p_virtual_date IN DATE) RETURN NUMBER IS
174:
175: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
176: l_value NUMBER;
177:
178:
179: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS

Line 181: FROM pay_defined_balances pdb

177:
178:
179: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
180: SELECT pdb.defined_balance_id
181: FROM pay_defined_balances pdb
182: ,pay_balance_types pbt
183: ,pay_balance_dimensions pbd
184: WHERE pbt.legislation_code='DK'
185: AND pbt.balance_name = p_balance_name

Line 215: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

211: ,p_balance_cat_name IN VARCHAR2
212: ,p_balance_dim IN VARCHAR2
213: ,p_virtual_date IN DATE) RETURN NUMBER IS
214:
215: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
216: l_tot_value NUMBER;
217:
218:
219: CURSOR get_dbal_id(p_balance_cat_name VARCHAR2 , p_balance_dim VARCHAR2) IS

Line 221: FROM pay_defined_balances pdb

217:
218:
219: CURSOR get_dbal_id(p_balance_cat_name VARCHAR2 , p_balance_dim VARCHAR2) IS
220: SELECT pdb.defined_balance_id DBAL_ID
221: FROM pay_defined_balances pdb
222: ,pay_balance_types pbt
223: ,pay_balance_dimensions pbd
224: ,pay_balance_categories_f pbc
225: WHERE pbc.category_name = p_balance_cat_name