DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on GL_CODE_COMBINATIONS

Line 4676: l_ccid GL_CODE_COMBINATIONS.Code_Combination_ID%TYPE;

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
4679: --
4680: -- Update the calling sequence

Line 4770: FROM gl_code_combinations

4766: END IF; -- If validate segments is TRUE
4767:
4768: SELECT account_type
4769: INTO l_acct_type
4770: FROM gl_code_combinations
4771: WHERE code_combination_id = l_ccid;
4772:
4773: IF l_acct_type <> 'L' THEN
4774: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 4881: FROM gl_code_combinations

4877: -- Validate liability account information
4878: BEGIN
4879: SELECT account_type
4880: INTO l_acct_type
4881: FROM gl_code_combinations
4882: WHERE code_combination_id =
4883: p_invoice_rec.accts_pay_code_combination_id;
4884:
4885: SELECT chart_of_accounts_id

Line 16298: FROM gl_code_combinations

16294: ELSE -- overlayed_ccid <> -1
16295: BEGIN
16296: SELECT 'X'
16297: INTO l_valid_dist_code
16298: FROM gl_code_combinations
16299: WHERE code_combination_id = l_overlayed_ccid
16300: AND enabled_flag='Y'
16301: AND NVL(END_date_active, p_accounting_date) --Bug 2923286 Changed gl_inv_sysdate to p_accounting_date
16302: >= p_accounting_date