APPS.PAY_IE_BAL_UPLOAD dependencies on PAY_TEMP_BALANCE_ADJUSTMENTS

Line 415: FROM pay_temp_balance_adjustments tba,

411: p_test_batch_line_id number
412: ) return number is
413: CURSOR csr_bal_adj_source_text (p_test_batch_line_id NUMBER, p_batch_line_id NUMBER) IS
414: SELECT tba.SOURCE_TEXT
415: FROM pay_temp_balance_adjustments tba,
416: pay_balance_batch_lines bbl
417: WHERE tba.batch_line_id = p_test_batch_line_id
418: AND bbl.batch_line_id = p_batch_line_id
419: AND tba.SOURCE_TEXT like nvl(bbl.SOURCE_TEXT,'%');

Line 427: FROM pay_temp_balance_adjustments tba,

423: -- we should let the bal adj happen for ASG_YTD and ASG_PTD
424:
425: CURSOR csr_bal_adj_orig_entry_id (p_test_batch_line_id NUMBER, p_batch_line_id NUMBER) IS
426: SELECT tba.original_entry_id
427: FROM pay_temp_balance_adjustments tba,
428: pay_balance_batch_lines bbl
429: WHERE tba.batch_line_id = p_test_batch_line_id
430: AND bbl.batch_line_id = p_batch_line_id
431: AND tba.original_entry_id = bbl.original_entry_id;