DBA Data[Home] [Help]

APPS.FA_GCCID_PKG dependencies on GL_CODE_COMBINATIONS

Line 205: FROM gl_code_combinations glcc

201: h_ccid_valid varchar2(10) := NULL;
202:
203: CURSOR validate_ccid IS
204: SELECT 'VALID'
205: FROM gl_code_combinations glcc
206: WHERE glcc.code_combination_id = X_rtn_ccid
207: AND glcc.enabled_flag = 'Y'
208: AND nvl(glcc.end_date_active, h_val_date) >=
209: h_val_date;

Line 714: FROM gl_code_combinations glcc

710: AND da.distribution_id = X_distribution_id;
711:
712: CURSOR validate_ccid IS
713: SELECT 'VALID'
714: FROM gl_code_combinations glcc
715: WHERE glcc.code_combination_id = X_rtn_ccid
716: AND glcc.enabled_flag = 'Y'
717: AND nvl(glcc.end_date_active, X_validation_date) >=
718: X_validation_date;