APPS.AP_IMPORT_UTILITIES_PKG dependencies on PO_HEADERS

Line 3274: po_headers

3270:
3271: /*===================================================================
3272: Private function: get_invoice_info
3273: Get some values for creating invoices from po_vendors,
3274: po_headers
3275: =================================================================== */
3276:
3277: FUNCTION get_invoice_info(
3278: p_invoice_rec IN OUT NOCOPY

Line 3862: (select po_header_id from po_headers where segment1 =p_invoice_rec.po_number

3858: DECODE(p_invoice_rec.doc_category_code, NULL,
3859: p_invoice_rec.voucher_num, ''), -- voucher_num
3860: --p_invoice_rec.exclusive_payment_flag, -- **exclusive_payment_flag
3861: DECODE(p_invoice_rec.invoice_type_lookup_code, 'CREDIT', 'N', p_invoice_rec.exclusive_payment_flag), -- BUG 7195865
3862: (select po_header_id from po_headers where segment1 =p_invoice_rec.po_number
3863: /* Added for bug#11702161 Start */
3864: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
3865: AND nvl(authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','IN PROCESS')
3866: /* Added for bug#11702161 End */

Line 3867: ), /* Bug 8556975 Changed po_headers_all to po_headers for * bug#9577089 */

3863: /* Added for bug#11702161 Start */
3864: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
3865: AND nvl(authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','IN PROCESS')
3866: /* Added for bug#11702161 End */
3867: ), /* Bug 8556975 Changed po_headers_all to po_headers for * bug#9577089 */
3868: p_invoice_rec.awt_group_id, -- awt_group_id
3869: p_invoice_rec.pay_awt_group_id, -- pay_awt_group_id--bug6639866
3870: p_invoice_rec.payment_cross_rate_type, -- payment_cross_rate_type
3871: p_invoice_rec.payment_cross_rate_date, -- payment_crosss_rate_date