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 1300: , P_Vendor_ID po_vendors.vendor_id%TYPE

1296: Bug 3609925
1297: ------------------------------------------------------------------------------------------------*/
1298: PROCEDURE Supp_Wh_ReDefault
1299: ( P_Invoice_Id ap_invoices_all.invoice_id%TYPE
1300: , P_Vendor_ID po_vendors.vendor_id%TYPE
1301: ) IS
1302:
1303: CURSOR Invoice_Distrib IS
1304: SELECT invoice_distribution_id