APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_INVOICES_ALL

Line 672: ap_invoices_all ainv,

668: AND NOT EXISTS ( select 'Advance Exists'
669: from po_distributions_all pod,
670: po_headers_all poh,
671: ap_invoice_distributions_all ainvd,
672: ap_invoices_all ainv,
673: po_doc_style_headers pdsa
674: where pod.po_distribution_id = D.po_distribution_id
675: and poh.po_header_id = pod.po_header_id
676: and poh.style_id = pdsa.style_id

Line 768: ap_invoices_all ainv,

764: AND NOT EXISTS ( select 'Advance Exists'
765: from po_distributions_all pod,
766: po_headers_all poh,
767: ap_invoice_distributions_all ainvd,
768: ap_invoices_all ainv,
769: po_doc_style_headers pdsa
770: where pod.po_distribution_id = T.po_distribution_id
771: and poh.po_header_id = pod.po_header_id
772: and poh.style_id = pdsa.style_id

Line 846: FROM AP_INVOICES_ALL

842: END IF;
843:
844: SELECT org_id
845: INTO l_org_id
846: FROM AP_INVOICES_ALL
847: WHERE invoice_id = p_invoice_id;
848:
849: IF (Encumbrance_Enabled(l_org_id)) THEN
850:

Line 2270: ap_invoices_all ai,

2266: NULL, --result_code
2267: NULL, --status_code
2268: 'N' self_assessed_flag --self_assessed_flag --bug7109594
2269: FROM ap_invoice_distributions_all aid,
2270: ap_invoices_all ai,
2271: ap_invoice_lines_all ail,
2272: gl_period_statuses per
2273: WHERE ai.invoice_id = p_invoice_id
2274: AND aid.invoice_id = ai.invoice_id

Line 2308: ap_invoices_all ai,

2304: NULL, -- result_code
2305: NULL, -- status_code
2306: 'N' self_assessed_flag -- self_assessed_flag --bug7109594
2307: FROM ap_invoice_distributions_all aid,
2308: ap_invoices_all ai,
2309: ap_invoice_lines_all ail,
2310: gl_period_statuses per,
2311: po_distributions_all pod
2312: WHERE ai.invoice_id = p_invoice_id

Line 2340: ap_invoices_all ainv,

2336: AND NOT EXISTS ( select 'Advance Exists'
2337: from po_distributions_all pod,
2338: po_headers_all poh,
2339: ap_invoice_distributions_all ainvd,
2340: ap_invoices_all ainv,
2341: po_doc_style_headers pdsa
2342: where pod.po_distribution_id = aid.po_distribution_id
2343: and poh.po_header_id = pod.po_header_id
2344: and poh.style_id = pdsa.style_id

Line 2369: ap_invoices_all ai,

2365: NULL, --result_code
2366: NULL, --status_code
2367: T.self_assessed_flag --self_assessed_flag --bug7109594
2368: FROM ap_self_assessed_tax_dist_all t,
2369: ap_invoices_all ai,
2370: gl_period_statuses per
2371: WHERE ai.invoice_id = p_invoice_id
2372: AND t.invoice_id = ai.invoice_id
2373: AND (p_inv_line_num IS NULL OR

Line 2403: ap_invoices_all ai,

2399: NULL, -- result_code
2400: NULL, -- status_code
2401: T.self_assessed_flag -- self_assessed_flag --bug7109594
2402: FROM ap_self_assessed_tax_dist_all t,
2403: ap_invoices_all ai,
2404: gl_period_statuses per
2405: WHERE ai.invoice_id = p_invoice_id
2406: AND t.invoice_id = ai.invoice_id
2407: AND (p_inv_line_num IS NULL OR

Line 2424: ap_invoices_all ainv,

2420: AND NOT EXISTS ( select 'Advance Exists'
2421: from po_distributions_all pod,
2422: po_headers_all poh,
2423: ap_invoice_distributions_all ainvd,
2424: ap_invoices_all ainv,
2425: po_doc_style_headers pdsa
2426: where pod.po_distribution_id = t.po_distribution_id
2427: and poh.po_header_id = pod.po_header_id
2428: and poh.style_id = pdsa.style_id

Line 2494: FROM AP_INVOICES_ALL

2490: END IF;
2491:
2492: SELECT org_id
2493: INTO l_org_id
2494: FROM AP_INVOICES_ALL
2495: WHERE invoice_id = p_invoice_id;
2496:
2497:
2498: /*-----------------------------------------------------------------+