DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on GL_CODE_COMBINATIONS

Line 4962: l_ccid GL_CODE_COMBINATIONS.Code_Combination_ID%TYPE;

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
4965: l_api_name CONSTANT VARCHAR2(100) := 'v_check_misc_invoice_info'; -- Bug 13904341
4966:

Line 5101: FROM gl_code_combinations

5097: END IF; -- If validate segments is TRUE
5098:
5099: SELECT account_type
5100: INTO l_acct_type
5101: FROM gl_code_combinations
5102: WHERE code_combination_id = l_ccid;
5103:
5104: IF l_acct_type <> 'L' THEN
5105: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 5212: FROM gl_code_combinations

5208: -- Validate liability account information
5209: BEGIN
5210: SELECT account_type
5211: INTO l_acct_type
5212: FROM gl_code_combinations
5213: WHERE code_combination_id =
5214: p_invoice_rec.accts_pay_code_combination_id;
5215:
5216: SELECT chart_of_accounts_id

Line 17883: FROM gl_code_combinations

17879: ELSE -- overlayed_ccid <> -1
17880: BEGIN
17881: SELECT 'X'
17882: INTO l_valid_dist_code
17883: FROM gl_code_combinations
17884: WHERE code_combination_id = l_overlayed_ccid
17885: AND enabled_flag='Y'
17886: AND NVL(END_date_active, p_accounting_date) --Bug 2923286 Changed gl_inv_sysdate to p_accounting_date
17887: >= p_accounting_date