APPS.PAY_ES_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 241: pay_balance_batch_lines bbl

237: CURSOR csr_bal_adj(p_test_batch_line_id NUMBER
238: ,p_batch_line_id NUMBER) IS
239: SELECT tba.source_text,tba.source_text2,tba.balance_type_id
240: FROM pay_temp_balance_adjustments tba,
241: pay_balance_batch_lines bbl
242: WHERE tba.batch_line_id = p_test_batch_line_id
243: AND bbl.batch_line_id = p_batch_line_id;
244: l_source_text1 VARCHAR2(10);
245: l_source_text2 VARCHAR2(10);

Line 253: FROM pay_balance_batch_lines

249: hr_utility.trace('Entering pay_es_bal_upload.include_adjustment stub');
250: --Select source text/source text2 of the current batch line
251: SELECT source_text ,source_text2
252: INTO l_source_text1 ,l_source_text2
253: FROM pay_balance_batch_lines
254: WHERE batch_line_id = p_batch_line_id;
255: --For context balances
256: IF (l_source_text1 IS NOT NULL) OR (l_source_text2 IS NOT NULL) THEN
257: OPEN csr_bal_adj(p_test_batch_line_id