eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 416: pay_balance_batch_lines bbl

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,'%');
420: -- Note above: included the like condiditon as for PRSI balances

Line 428: pay_balance_batch_lines bbl

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;
432: