APPS.PAY_DK_STATSR_PKG dependencies on PAY_DEFINED_BALANCES

Line 176: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

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

Line 182: FROM pay_defined_balances pdb

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

Line 216: l_context1 PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

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

Line 222: FROM pay_defined_balances pdb

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