DBA Data[Home] [Help]

APPS.FA_GCCID_PKG dependencies on GL_CODE_COMBINATIONS

Line 188: FROM gl_code_combinations glcc

184: h_ccid_valid varchar2(10) := NULL;
185:
186: CURSOR validate_ccid IS
187: SELECT 'VALID'
188: FROM gl_code_combinations glcc
189: WHERE glcc.code_combination_id = X_rtn_ccid
190: AND glcc.enabled_flag = 'Y'
191: AND nvl(glcc.end_date_active, h_val_date) >=
192: h_val_date;

Line 702: FROM gl_code_combinations glcc

698: AND da.distribution_id = X_distribution_id;
699:
700: CURSOR validate_ccid IS
701: SELECT 'VALID'
702: FROM gl_code_combinations glcc
703: WHERE glcc.code_combination_id = X_rtn_ccid
704: AND glcc.enabled_flag = 'Y'
705: AND nvl(glcc.end_date_active, X_validation_date) >=
706: X_validation_date;