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.FV_TREASURY_PAYMENTS_PKG dependencies on FV_TC_OFFSETS

Line 287: l_corr_treas_pay_num fv_tc_offsets.corrected_treasury_pay_number%TYPE;

283: l_checkrun_name fv_treasury_confirmations_all.checkrun_name%TYPE;
284: l_select_str VARCHAR2(1000);
285: TYPE t_refcur IS REF CURSOR;
286: l_upg_check_id_cur t_refcur;
287: l_corr_treas_pay_num fv_tc_offsets.corrected_treasury_pay_number%TYPE;
288: l_offset_check_id fv_tc_offsets.check_id%TYPE;
289:
290: -- declare array to store check_ids
291: TYPE l_check_row IS RECORD (CHECK_ID NUMBER(15)) ;

Line 288: l_offset_check_id fv_tc_offsets.check_id%TYPE;

284: l_select_str VARCHAR2(1000);
285: TYPE t_refcur IS REF CURSOR;
286: l_upg_check_id_cur t_refcur;
287: l_corr_treas_pay_num fv_tc_offsets.corrected_treasury_pay_number%TYPE;
288: l_offset_check_id fv_tc_offsets.check_id%TYPE;
289:
290: -- declare array to store check_ids
291: TYPE l_check_row IS RECORD (CHECK_ID NUMBER(15)) ;
292: TYPE l_check_tbl_type IS TABLE OF l_check_row INDEX BY BINARY_INTEGER;

Line 306: FROM fv_tc_offsets fto,

302: ORDER BY ac.check_id;
303:
304: CURSOR cur_corr_treas_pay_num IS
305: SELECT fto.corrected_treasury_pay_number, fto.check_id
306: FROM fv_tc_offsets fto,
307: ap_checks ac,
308: iby_pay_instructions_all ipa
309: WHERE ac.check_id = fto.check_id
310: AND ipa.payment_instruction_id = ac.payment_instruction_id