DBA Data[Home] [Help]

APPS.FV_SLA_AP_PROCESSING_PKG dependencies on XLA_EVENTS_GT

Line 111: xla_events_gt e,

107: ai.vendor_id,
108: aid.project_id,
109: aid.invoice_distribution_id line_number
110: FROM ap_invoice_distributions_all aid,
111: xla_events_gt e,
112: ap_invoices_all ai
113: WHERE aid.bc_event_id = e.event_id
114: AND e.application_id = p_application_id
115: AND e.entity_code = 'AP_INVOICES'

Line 164: xla_events_gt e,

160: ai.vendor_id,
161: asat.project_id,
162: asat.invoice_distribution_id line_number
163: FROM ap_self_assessed_tax_dist_all asat,
164: xla_events_gt e,
165: ap_invoices_all ai
166: WHERE asat.bc_event_id = e.event_id
167: AND e.application_id = p_application_id
168: AND e.entity_code = 'AP_INVOICES'

Line 218: xla_events_gt e,

214: aid.project_id,
215: apad.prepay_app_dist_id line_number
216: FROM ap_invoice_distributions_all aid,
217: ap_prepay_app_dists apad,
218: xla_events_gt e,
219: ap_invoices_all ai
220: WHERE aid.bc_event_id = e.event_id
221: AND e.application_id = p_application_id
222: AND e.entity_code = 'AP_INVOICES'

Line 512: p_application_id IN xla_events_gt.application_id%TYPE,

508: END;
509:
510: PROCEDURE process_payments
511: (
512: p_application_id IN xla_events_gt.application_id%TYPE,
513: p_fv_extract_detail IN OUT NOCOPY fv_sla_utl_processing_pkg.fv_ref_detail,
514: p_error_code OUT NOCOPY NUMBER,
515: p_error_desc OUT NOCOPY VARCHAR2
516: )

Line 570: xla_events_gt e,

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,
571: ap_invoices_all ai
572: WHERE aphd.accounting_event_id = e.event_id
573: AND e.application_id = p_application_id
574: AND aphd.invoice_distribution_id = aid.invoice_distribution_id

Line 619: xla_events_gt e,

615: ai.vendor_id
616: FROM ap_payment_hist_dists aphd,
617: ap_invoice_distributions_all aid,
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

Line 666: xla_events_gt e,

662: ai.vendor_id
663: FROM ap_payment_hist_dists aphd,
664: ap_invoice_distributions_all aid,
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