APPS.PA_DEDUCTIONS dependencies on AP_INVOICES_ALL

Line 781: FROM AP_INVOICES_ALL

777: p_org_id PA_DEDUCTIONS_ALL.org_id%TYPE) is
778: SELECT 'N'
779: FROM DUAL WHERE EXISTS (
780: SELECT 1
781: FROM AP_INVOICES_ALL
782: WHERE invoice_num = p_debit_memo_num
783: AND vendor_id = p_vendor_id
784: AND org_id = p_org_id
785: UNION ALL

Line 2171: SELECT invoice_id FROM AP_INVOICES_ALL WHERE

2167: DELETE AP_INVOICES_INTERFACE WHERE
2168: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id);
2169:
2170: DELETE AP_INVOICE_DISTRIBUTIONS_ALL WHERE invoice_id IN(
2171: SELECT invoice_id FROM AP_INVOICES_ALL WHERE
2172: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id));
2173:
2174: DELETE AP_INVOICE_LINES_ALL WHERE invoice_id IN(
2175: SELECT invoice_id FROM AP_INVOICES_ALL WHERE

Line 2175: SELECT invoice_id FROM AP_INVOICES_ALL WHERE

2171: SELECT invoice_id FROM AP_INVOICES_ALL WHERE
2172: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id));
2173:
2174: DELETE AP_INVOICE_LINES_ALL WHERE invoice_id IN(
2175: SELECT invoice_id FROM AP_INVOICES_ALL WHERE
2176: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id));
2177:
2178: DELETE AP_INVOICES_ALL WHERE
2179: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id);

Line 2178: DELETE AP_INVOICES_ALL WHERE

2174: DELETE AP_INVOICE_LINES_ALL WHERE invoice_id IN(
2175: SELECT invoice_id FROM AP_INVOICES_ALL WHERE
2176: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id));
2177:
2178: DELETE AP_INVOICES_ALL WHERE
2179: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id);
2180:
2181: END Delete_Failed_Rec;
2182:

Line 2206: FROM AP_INVOICES_ALL

2202: p_vendor_id PA_DEDUCTIONS_ALL.vendor_id%TYPE) IS
2203: SELECT 'N'
2204: FROM DUAL WHERE EXISTS (
2205: SELECT 1
2206: FROM AP_INVOICES_ALL
2207: WHERE invoice_num = p_debit_memo_num
2208: AND vendor_id = p_vendor_id
2209: AND org_id = p_org_id
2210: UNION ALL

Line 2387: FROM ap_invoices_all apinv

2383: p_vendor_site_id NUMBER,
2384: ded_req_num IN VARCHAR2) RETURN VARCHAR2 IS
2385: CURSOR C1 IS
2386: SELECT invoice_num
2387: FROM ap_invoices_all apinv
2388: WHERE apinv.vendor_id = p_vendor_id
2389: AND apinv.vendor_site_id = p_vendor_site_id
2390: AND EXISTS
2391: (SELECT 1 FROM ap_invoice_distributions_all

Line 2393: AND parent_invoice_id = ( SELECT invoice_id from ap_invoices_all

2389: AND apinv.vendor_site_id = p_vendor_site_id
2390: AND EXISTS
2391: (SELECT 1 FROM ap_invoice_distributions_all
2392: WHERE invoice_id = apinv.invoice_id
2393: AND parent_invoice_id = ( SELECT invoice_id from ap_invoices_all
2394: WHERE source = 'Oracle Project Accounting'
2395: AND invoice_type_lookup_code = 'DEBIT'
2396: AND product_table='PA_DEDUCTIONS_ALL'
2397: AND reference_key1 = ded_req_num));

Line 2472: Procedure validate_unprocessed_ded ( invoice_id IN ap_invoices_all.invoice_id%type,

2468: -- Parameters Type Required Description
2469: -- invoice_id NUMBER YES invoice_id being validated
2470: -- cmt_exist_flag VARCHAR returns whether unprocessed dedns exist
2471: ---------------------------------------------------------------------------------------------------------
2472: Procedure validate_unprocessed_ded ( invoice_id IN ap_invoices_all.invoice_id%type,
2473: cmt_exist_flag OUT NOCOPY VARCHAR2)
2474:
2475: */
2476: