APPS.FV_DISB_IN_TRANSIT dependencies on FV_TC_OFFSETS

Line 86: v_corr_treas_pay_num fv_tc_offsets.corrected_treasury_pay_number%TYPE;

82: v_delta NUMBER(15);
83: v_treasury_pay_number ap_checks.treasury_pay_number%TYPE;
84:
85: -- AKA declare variables for offsets
86: v_corr_treas_pay_num fv_tc_offsets.corrected_treasury_pay_number%TYPE;
87: v_offset_check_id fv_tc_offsets.check_id%TYPE;
88: v_pay_fmt_program_name ap_payment_programs.program_name%TYPE;
89:
90: -- declare array to store check_ids

Line 87: v_offset_check_id fv_tc_offsets.check_id%TYPE;

83: v_treasury_pay_number ap_checks.treasury_pay_number%TYPE;
84:
85: -- AKA declare variables for offsets
86: v_corr_treas_pay_num fv_tc_offsets.corrected_treasury_pay_number%TYPE;
87: v_offset_check_id fv_tc_offsets.check_id%TYPE;
88: v_pay_fmt_program_name ap_payment_programs.program_name%TYPE;
89:
90: -- declare array to store check_ids
91: TYPE l_check_row IS RECORD ( CHECK_ID NUMBER(15)) ;

Line 105: FROM fv_tc_offsets fto,

101: -- need to join to ap_checks on check id to get the correct batch name
102:
103: CURSOR cur_corr_treas_pay_num IS
104: SELECT fto.corrected_treasury_pay_number, fto.check_id
105: FROM fv_tc_offsets fto,
106: ap_checks ac,
107: iby_payments_all ipa
108: WHERE ac.check_id = fto.check_id
109: AND ac.payment_id = ipa.payment_id

Line 1892: DELETE FROM fv_tc_offsets

1888:
1889: --delete the offset record related to this payment
1890: --batch.
1891:
1892: DELETE FROM fv_tc_offsets
1893: WHERE check_id IN (SELECT check_id
1894: FROM ap_checks ac,
1895: fv_treasury_confirmations ftc,
1896: iby_payments_all ipa