DBA Data[Home] [Help]

APPS.PAY_NO_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 206: pay_balance_batch_lines bbl

202:
203: CURSOR csr_bal_adj (p_test_batch_line_id NUMBER, p_batch_line_id NUMBER) IS
204: SELECT tba.source_text , tba.tax_unit_id
205: FROM pay_temp_balance_adjustments tba,
206: pay_balance_batch_lines bbl
207: WHERE tba.balance_type_id = bbl.balance_type_id
208: AND tba.batch_line_id = p_test_batch_line_id
209: AND bbl.batch_line_id = p_batch_line_id
210: AND nvl(tba.source_text ,0) = nvl(bbl.source_text ,0);