DBA Data[Home] [Help]

APPS.FV_SLA_AP_PROCESSING_PKG dependencies on AP_CHECKS_ALL

Line 566: FROM ap_checks_all aca,

562: ai.product_table ref_product_table,
563: ai.reference_key1 ref_key1,
564: ai.reference_key2 ref_key2,
565: ai.vendor_id
566: FROM ap_checks_all aca,
567: ap_payment_hist_dists aphd,
568: ap_invoice_distributions_all aid,
569: ap_payment_history_all aph,
570: xla_events_gt e,

Line 622: ap_checks_all aca

618: ap_payment_history_all aph,
619: xla_events_gt e,
620: ap_invoices_all ai,
621: fv_treasury_confirmations_all ftc,
622: ap_checks_all aca
623: WHERE ftc.event_id = e.event_id
624: AND aca.payment_instruction_id = ftc.payment_instruction_id
625: AND aph.check_id = aca.check_id
626: AND aca.check_id NOT IN (SELECT check_id

Line 669: ap_checks_all aca

665: ap_payment_history_all aph,
666: xla_events_gt e,
667: ap_invoices_all ai,
668: fv_voided_checks fvc,
669: ap_checks_all aca
670: WHERE fvc.event_id = e.event_id
671: AND aca.payment_instruction_id = fvc.payment_instruction_id
672: AND fvc.check_id = aca.check_id
673: AND aph.check_id = aca.check_id