DBA Data[Home] [Help]

APPS.AP_CUSTOM_INT_INV_PKG dependencies on AP_INVOICES

Line 70: from ap_invoices

66: -- package for interest calculation
67:
68:
69: Select org_id into l_org_id
70: from ap_invoices
71: where invoice_id=p_invoice_id;
72:
73: debug_info := 'apcci Invoice_id: '||to_char(p_invoice_id) ||
74: ' Org_id: '|| l_org_id;

Line 142: -- Get vendor_site_id from ap_invoices

138: --
139: -- Get payment_location
140: FND_PROFILE.GET('JLBR_PAYMENT_LOCATION',l_payment_location);
141:
142: -- Get vendor_site_id from ap_invoices
143: SELECT vendor_site_id
144: INTO l_vendor_site_id
145: FROM ap_invoices
146: WHERE invoice_id = p_invoice_id;

Line 145: FROM ap_invoices

141:
142: -- Get vendor_site_id from ap_invoices
143: SELECT vendor_site_id
144: INTO l_vendor_site_id
145: FROM ap_invoices
146: WHERE invoice_id = p_invoice_id;
147:
148: IF NVL(l_payment_location,'$') = '1' THEN -- 1 COMPANY
149: -- Get city from ap_system_parameters