APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on GL_CODE_COMBINATIONS

Line 3847: FROM gl_code_combinations

3843: -- Validate the Charge Code Combination Id
3844: BEGIN
3845: IF P_Cc_Acct_Date IS NOT NULL THEN
3846: SELECT code_combination_id INTO l_code_combination_id
3847: FROM gl_code_combinations
3848: WHERE code_combination_id = P_Charge_Code_Combination_Id
3849: AND enabled_flag = 'Y'
3850: AND P_Cc_Acct_Date BETWEEN NVL(start_date_active, P_Cc_Acct_Date)
3851: AND NVL(end_date_active, P_Cc_Acct_Date);

Line 3854: FROM gl_code_combinations

3850: AND P_Cc_Acct_Date BETWEEN NVL(start_date_active, P_Cc_Acct_Date)
3851: AND NVL(end_date_active, P_Cc_Acct_Date);
3852: ELSE
3853: SELECT code_combination_id INTO l_code_combination_id
3854: FROM gl_code_combinations
3855: WHERE code_combination_id = P_Charge_Code_Combination_Id
3856: AND enabled_flag = 'Y';
3857: END IF;
3858: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3878: FROM gl_code_combinations

3874: -- Validate the Budget Code Combination Id
3875: BEGIN
3876: IF P_Cc_Acct_Date IS NOT NULL THEN
3877: SELECT code_combination_id INTO l_code_combination_id
3878: FROM gl_code_combinations
3879: WHERE code_combination_id = P_Budget_Code_Combination_Id
3880: AND enabled_flag = 'Y'
3881: AND P_Cc_Acct_Date BETWEEN NVL(start_date_active, P_Cc_Acct_Date)
3882: AND NVL(end_date_active, P_Cc_Acct_Date);

Line 3885: FROM gl_code_combinations

3881: AND P_Cc_Acct_Date BETWEEN NVL(start_date_active, P_Cc_Acct_Date)
3882: AND NVL(end_date_active, P_Cc_Acct_Date);
3883: ELSE
3884: SELECT code_combination_id INTO l_code_combination_id
3885: FROM gl_code_combinations
3886: WHERE code_combination_id = P_Budget_Code_Combination_Id
3887: AND enabled_flag = 'Y';
3888: END IF;
3889: EXCEPTION WHEN NO_DATA_FOUND THEN