DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_LOOKUP_CODES

Line 4674: l_valid_pay_group PO_LOOKUP_CODES.Lookup_Code%TYPE;

4670: l_chart_of_accounts_id NUMBER;
4671: l_catsegs VARCHAR2(200);
4672: l_acct_type VARCHAR2(1);
4673: -- Bug 5448579
4674: l_valid_pay_group PO_LOOKUP_CODES.Lookup_Code%TYPE;
4675: -- Bug 6509776
4676: l_ccid GL_CODE_COMBINATIONS.Code_Combination_ID%TYPE;
4677:
4678: BEGIN

Line 5091: FROM po_lookup_codes

5087: /* -- Invalid Info
5088: BEGIN
5089: SELECT 'X'
5090: INTO l_valid_info
5091: FROM po_lookup_codes
5092: WHERE lookup_code = p_invoice_rec.pay_group_lookup_code
5093: AND lookup_type = 'PAY GROUP'
5094: AND DECODE(SIGN(NVL(inactive_date,
5095: AP_IMPORT_INVOICES_PKG.g_inv_sysdate) -