DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_LOOKUP_CODES

Line 4960: l_valid_pay_group PO_LOOKUP_CODES.Lookup_Code%TYPE;

4956: l_chart_of_accounts_id NUMBER;
4957: l_catsegs VARCHAR2(200);
4958: l_acct_type VARCHAR2(1);
4959: -- Bug 5448579
4960: l_valid_pay_group PO_LOOKUP_CODES.Lookup_Code%TYPE;
4961: -- Bug 6509776
4962: l_ccid GL_CODE_COMBINATIONS.Code_Combination_ID%TYPE;
4963:
4964: l_debug_info VARCHAR2(2000); -- Bug 13904341

Line 5423: FROM po_lookup_codes

5419: /* -- Invalid Info
5420: BEGIN
5421: SELECT 'X'
5422: INTO l_valid_info
5423: FROM po_lookup_codes
5424: WHERE lookup_code = p_invoice_rec.pay_group_lookup_code
5425: AND lookup_type = 'PAY GROUP'
5426: AND DECODE(SIGN(NVL(inactive_date,
5427: AP_IMPORT_INVOICES_PKG.g_inv_sysdate) -