APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_INVOICES_ALL

Line 289: FROM ap_invoices_all AI

285: P_ppa_exists := 'Y';
286: debug_info := 'Get Existing Ppa_invoice_id';
287: SELECT invoice_id
288: INTO p_existing_ppa_inv_id -- Bug 5525506
289: FROM ap_invoices_all AI
290: WHERE invoice_type_lookup_code = 'PO PRICE ADJUST'
291: AND source = 'PPA'
292: AND ai.invoice_id = (SELECT MAX(invoice_id)
293: FROM ap_invoice_lines_all

Line 2062: FROM ap_invoices_all AI,

2058: ai.TRX_BUSINESS_CATEGORY ,
2059: ai.UNIQUE_REMITTANCE_IDENTIFIER ,
2060: ai.URI_CHECK_DIGIT ,
2061: ai.USER_DEFINED_FISC_CLASS
2062: FROM ap_invoices_all AI,
2063: ap_invoices_interface AII
2064: WHERE AII.invoice_id = p_instruction_id -- instruction_rec.invoice_id
2065: AND AI.vendor_id = AII.vendor_id
2066: AND AI.invoice_id = p_invoice_id; -- base_match_lines_rec.invoice_id

Line 2071: l_description AP_INVOICES_ALL.description%TYPE;

2067:
2068: l_new_ppa_count NUMBER;
2069: l_existing_ppa_count NUMBER;
2070: l_ppa_invoice_rec AP_RETRO_PRICING_PKG.invoice_rec_type;
2071: l_description AP_INVOICES_ALL.description%TYPE;
2072: l_dbseqnm VARCHAR2(30);
2073: l_seqassid NUMBER;
2074: l_seq_num_profile VARCHAR2(80);
2075: l_return_code NUMBER;

Line 2124: FROM ap_invoices_all I

2120: END IF;
2121: -----------------------------------------------------------------
2122: SELECT count(*)
2123: INTO l_existing_ppa_count
2124: FROM ap_invoices_all I
2125: WHERE I.source = 'PPA'
2126: AND EXISTS (SELECT invoice_id
2127: FROM ap_invoice_lines_all L
2128: WHERE L.invoice_id = I.invoice_id

Line 2455: FROM ap_invoices_all

2451: BEGIN
2452: debug_info := 'Get invoice_num for the corrected invoice';
2453: SELECT invoice_num
2454: INTO l_invoice_num
2455: FROM ap_invoices_all
2456: WHERE invoice_id = p_invoice_id;
2457:
2458: RETURN l_invoice_num;
2459: