APPS.AP_APPROVAL_PKG dependencies on GL_CODE_COMBINATIONS

Line 4058: from gl_code_combinations C

4054: FROM ap_invoice_distributions D
4055: WHERE D.invoice_id = p_invoice_id
4056: AND D.posted_flag||'' in ('N', 'P')
4057: AND ((EXISTS (select 'x'
4058: from gl_code_combinations C
4059: where D.dist_code_combination_id = C.code_combination_id (+)
4060: and (C.code_combination_id is null
4061: or C.detail_posting_allowed_flag = 'N'
4062: or C.start_date_active > D.accounting_date

Line 4073: FROM gl_code_combinations glcc

4069: AND ROWNUM = 1;
4070:
4071: CURSOR Alternate_Account_Cur (c_ccid NUMBER, c_acct_date DATE) IS
4072: SELECT 'Y'
4073: FROM gl_code_combinations glcc
4074: WHERE glcc.code_combination_id = c_ccid
4075: AND glcc.alternate_code_combination_id IS NOT NULL
4076: AND EXISTS
4077: (

Line 4079: FROM gl_code_combinations a

4075: AND glcc.alternate_code_combination_id IS NOT NULL
4076: AND EXISTS
4077: (
4078: SELECT 'Account Valid'
4079: FROM gl_code_combinations a
4080: WHERE a.code_combination_id = glcc.alternate_code_combination_id
4081: AND a.enabled_flag = 'Y'
4082: AND a.detail_posting_allowed_flag = 'Y'
4083: AND c_acct_date BETWEEN NVL(a.start_date_active, c_acct_date)

Line 9010: FROM gl_code_combinations

9006:
9007: BEGIN
9008: SELECT account_type
9009: INTO l_account_type
9010: FROM gl_code_combinations
9011: WHERE code_combination_id = l_dist_tab(i).dist_code_combination_id;
9012:
9013: EXCEPTION
9014: WHEN NO_DATA_FOUND THEN