DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_PPA_INVOICES_GT

Line 2175: FROM ap_ppa_invoices_gt apig

2171:
2172: --Introduced below SELECT for bug#9855094
2173: SELECT count(*)
2174: INTO l_temp_ppa_count
2175: FROM ap_ppa_invoices_gt apig
2176: WHERE instruction_id = p_instruction_id
2177: and exists(select invoice_id
2178: from ap_ppa_invoice_lines_gt apilg
2179: where apilg.invoice_id = apig.invoice_id

Line 2196: debug_info := 'Create_Ppa_Invoice Step :6 Insert into ap_ppa_invoices_gt';

2192: END IF;
2193: -- Removed step 4 and step 5 for bug8514744
2194: -- Same logic moved to apretrob.pls
2195: ------------------------------------------------
2196: debug_info := 'Create_Ppa_Invoice Step :6 Insert into ap_ppa_invoices_gt';
2197: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
2198: AP_IMPORT_UTILITIES_PKG.Print(
2199: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
2200: END IF;

Line 2202: INSERT INTO ap_ppa_invoices_gt(

2198: AP_IMPORT_UTILITIES_PKG.Print(
2199: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
2200: END IF;
2201: ------------------------------------------------
2202: INSERT INTO ap_ppa_invoices_gt(
2203: accts_pay_code_combination_id,
2204: amount_applicable_to_discount,
2205: approval_ready_flag,
2206: attribute_category,