APPS.PAY_NL_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 379: pay_balance_batch_lines bbl

375:
376: CURSOR csr_bal_adj(p_test_batch_line_id NUMBER, p_batch_line_id NUMBER) IS
377: SELECT tba.source_text,tba.balance_type_id
378: FROM pay_temp_balance_adjustments tba,
379: pay_balance_batch_lines bbl
380: WHERE tba.batch_line_id = p_test_batch_line_id
381: AND bbl.batch_line_id = p_batch_line_id;
382:
383: l_source_text1 varchar2(10);

Line 390: select source_text into l_source_text1 from pay_balance_batch_lines where batch_line_id=p_batch_line_id;

386: begin
387: hr_utility.trace('Entering pay_nl_bal_upload.include_adjustment stub');
388:
389: --Select source text of the current batch line
390: select source_text into l_source_text1 from pay_balance_batch_lines where batch_line_id=p_batch_line_id;
391:
392: --For context balances
393: if l_source_text1 is not null then
394: open csr_bal_adj(p_test_batch_line_id,p_batch_line_id);