APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_INVOICES_ALL

Line 293: FROM ap_invoices_all AI

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

Line 2098: FROM ap_invoices_all AI,

2094: ai.TRX_BUSINESS_CATEGORY ,
2095: ai.UNIQUE_REMITTANCE_IDENTIFIER ,
2096: ai.URI_CHECK_DIGIT ,
2097: ai.USER_DEFINED_FISC_CLASS
2098: FROM ap_invoices_all AI,
2099: ap_invoices_interface AII
2100: WHERE AII.invoice_id = p_instruction_id -- instruction_rec.invoice_id
2101: AND AI.vendor_id = AII.vendor_id
2102: AND AI.invoice_id = p_invoice_id; -- base_match_lines_rec.invoice_id

Line 2108: l_description AP_INVOICES_ALL.description%TYPE;

2104: l_new_ppa_count NUMBER;
2105: l_existing_ppa_count NUMBER;
2106: l_temp_ppa_count NUMBER; --bug#9855094
2107: l_ppa_invoice_rec AP_RETRO_PRICING_PKG.invoice_rec_type;
2108: l_description AP_INVOICES_ALL.description%TYPE;
2109: l_dbseqnm VARCHAR2(30);
2110: l_seqassid NUMBER;
2111: l_seq_num_profile VARCHAR2(80);
2112: l_return_code NUMBER;

Line 2161: FROM ap_invoices_all I

2157: END IF;
2158: -----------------------------------------------------------------
2159: SELECT count(*)
2160: INTO l_existing_ppa_count
2161: FROM ap_invoices_all I
2162: WHERE I.source = 'PPA'
2163: AND EXISTS (SELECT invoice_id
2164: FROM ap_invoice_lines_all L
2165: WHERE L.invoice_id = I.invoice_id

Line 2448: FROM ap_invoices_all

2444: BEGIN
2445: debug_info := 'Get invoice_num for the corrected invoice';
2446: SELECT invoice_num
2447: INTO l_invoice_num
2448: FROM ap_invoices_all
2449: WHERE invoice_id = p_invoice_id;
2450:
2451: RETURN l_invoice_num;
2452: