APPS.FV_DISB_IN_TRANSIT dependencies on IBY_PAYMENTS_ALL

Line 107: iby_payments_all ipa

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
110: AND ipa.payment_instruction_id = v_payment_instruction_id
111: AND ipa.org_id = v_org_id;

Line 371: iby_payments_all ipa

367: FROM fv_treasury_confirmations ftc,
368: ap_checks ac,
369: ap_invoice_payments aip,
370: ap_ae_lines apd,
371: iby_payments_all ipa
372: WHERE ftc.treasury_confirmation_id = x_treasury_confirmation_id
373: AND ftc.payment_instruction_id = ipa.payment_instruction_id
374: AND ipa.payment_id = ac.payment_id
375: AND ac.check_id = aip.check_id

Line 1060: iby_payments_all ipa

1056: FROM fv_treasury_confirmations_all ftc,
1057: fv_voided_checks fvt,
1058: ap_checks_all ac ,
1059: ap_invoice_payments_all apip,
1060: iby_payments_all ipa
1061: WHERE ac.check_id = fvt.check_id
1062: AND ac.payment_id = ipa.payment_id
1063: AND ipa.payment_instruction_id = ftc.payment_instruction_id
1064: AND ftc.checkrun_name IS NULL

Line 1878: iby_payments_all ipa

1874: last_update_login = fnd_global.login_id
1875: WHERE payment_id IN
1876: (SELECT payment_id
1877: FROM fv_treasury_confirmations ftca,
1878: iby_payments_all ipa
1879: WHERE ftca.treasury_confirmation_id = v_treasury_confirmation_id
1880: AND ftca.payment_instruction_id = ipa.payment_instruction_id);
1881:
1882: UPDATE fv_treasury_confirmations

Line 1896: iby_payments_all ipa

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
1897: WHERE ftc.treasury_confirmation_id = v_treasury_confirmation_id
1898: AND ftc.payment_instruction_id = ipa.payment_instruction_id
1899: AND ipa.payment_id = ac.payment_id);
1900: