239:
240: CURSOR csr_bal_adj(p_test_batch_line_id NUMBER, p_batch_line_id NUMBER) IS
241: SELECT tba.source_text,tba.balance_type_id
242: FROM pay_temp_balance_adjustments tba,
243: pay_balance_batch_lines bbl
244: WHERE tba.batch_line_id = p_test_batch_line_id
245: AND bbl.batch_line_id = p_batch_line_id;
246:
247: l_source_text1 varchar2(10);
250: begin
251: hr_utility.trace('Entering pay_kw_bal_upload.include_adjustment stub');
252:
253: --Select source text of the current batch line
254: select source_text into l_source_text1 from pay_balance_batch_lines where batch_line_id=p_batch_line_id;
255:
256: --For context balances
257: if l_source_text1 is not null then
258: open csr_bal_adj(p_test_batch_line_id,p_batch_line_id);