APPS.FV_TREASURY_PAYMENTS_PKG dependencies on FV_TC_OFFSETS

Line 291: l_corr_treas_pay_num fv_tc_offsets.corrected_treasury_pay_number%TYPE;

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

Line 292: l_offset_check_id fv_tc_offsets.check_id%TYPE;

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

Line 309: FROM fv_tc_offsets fto,

305: AND ac.org_id = g_org_id;
306:
307: CURSOR cur_corr_treas_pay_num IS
308: SELECT fto.corrected_treasury_pay_number, fto.check_id
309: FROM fv_tc_offsets fto,
310: ap_checks ac,
311: iby_pay_instructions_all ipa
312: WHERE ac.check_id = fto.check_id
313: AND ipa.payment_instruction_id = ac.payment_instruction_id