APPS.AP_APPROVAL_PKG dependencies on GL_CODE_COMBINATIONS

Line 2955: from gl_code_combinations C

2951: FROM ap_invoice_distributions D
2952: WHERE D.invoice_id = p_invoice_id
2953: AND D.posted_flag||'' in ('N', 'P')
2954: AND ((EXISTS (select 'x'
2955: from gl_code_combinations C
2956: where D.dist_code_combination_id = C.code_combination_id (+)
2957: and (C.code_combination_id is null
2958: or C.detail_posting_allowed_flag = 'N'
2959: or C.start_date_active > D.accounting_date

Line 2970: FROM gl_code_combinations glcc

2966: AND ROWNUM = 1;
2967:
2968: CURSOR Alternate_Account_Cur (c_ccid NUMBER, c_acct_date DATE) IS
2969: SELECT 'Y'
2970: FROM gl_code_combinations glcc
2971: WHERE glcc.code_combination_id = c_ccid
2972: AND glcc.alternate_code_combination_id IS NOT NULL
2973: AND EXISTS
2974: (

Line 2976: FROM gl_code_combinations a

2972: AND glcc.alternate_code_combination_id IS NOT NULL
2973: AND EXISTS
2974: (
2975: SELECT 'Account Valid'
2976: FROM gl_code_combinations a
2977: WHERE a.code_combination_id = glcc.alternate_code_combination_id
2978: AND a.enabled_flag = 'Y'
2979: AND a.detail_posting_allowed_flag = 'Y'
2980: AND c_acct_date BETWEEN NVL(a.start_date_active, c_acct_date)

Line 6932: FROM gl_code_combinations

6928:
6929: BEGIN
6930: SELECT account_type
6931: INTO l_account_type
6932: FROM gl_code_combinations
6933: WHERE code_combination_id = l_dist_tab(i).dist_code_combination_id;
6934:
6935: EXCEPTION
6936: WHEN NO_DATA_FOUND THEN