APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on PO_VENDORS

Line 217: -- Get the information from po_vendors when tax_payerid is not null

213: , P_Invoice_Id ap_invoices_all.invoice_id%TYPE
214: )
215: return number is
216: --------------------------------------------------------------------
217: -- Get the information from po_vendors when tax_payerid is not null
218: --------------------------------------------------------------------
219: CURSOR TaxPayerID_Po_Ven IS
220: SELECT Vendor_Id
221: FROM po_vendors

Line 221: FROM po_vendors

217: -- Get the information from po_vendors when tax_payerid is not null
218: --------------------------------------------------------------------
219: CURSOR TaxPayerID_Po_Ven IS
220: SELECT Vendor_Id
221: FROM po_vendors
222: WHERE segment1 = P_Tax_Payer_Id; -- R12 KI : Need to uptake PTP?
223:
224: --------------------------------------------------------------------
225: -- Get the information from ap_invoices_all when tax_payerid is null.

Line 232: v_vendor_id po_vendors.vendor_id%TYPE;

228: SELECT Vendor_Id
229: FROM ap_invoices
230: WHERE invoice_id = P_Invoice_Id;
231:
232: v_vendor_id po_vendors.vendor_id%TYPE;
233:
234: BEGIN
235: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
236: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Get_Vendor_Id','Start FUNCTION Get_Vendor_Id');

Line 1364: , P_Vendor_ID po_vendors.vendor_id%TYPE

1360: Bug 3609925
1361: ------------------------------------------------------------------------------------------------*/
1362: PROCEDURE Supp_Wh_ReDefault
1363: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
1364: , P_Vendor_ID po_vendors.vendor_id%TYPE
1365: ) IS
1366:
1367: CURSOR Invoice_Distrib IS
1368: SELECT invoice_distribution_id