APPS.OKS_IMPORT_VALIDATE dependencies on OKS_INT_COVERED_LEVEL_STG_TEMP

Line 4129: INTO OKS_INT_COVERED_LEVEL_STG_TEMP

4125: l_stmt_num := 70;
4126:
4127: INSERT ALL
4128: WHEN (1=1) THEN
4129: INTO OKS_INT_COVERED_LEVEL_STG_TEMP
4130: (COVERED_LEVEL_INTERFACE_ID
4131: ,LINE_INTERFACE_ID
4132: ,HEADER_INTERFACE_ID
4133: ,COVERED_INSTANCE_ID

Line 4725: SELECT count(1) INTO l_stg_count FROM OKS_INT_COVERED_LEVEL_STG_TEMP;

4721: SELECT count(1) INTO l_int_count FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4722: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
4723: WHERE LINE_INTERFACE_ID = OCLI.LINE_INTERFACE_ID);
4724:
4725: SELECT count(1) INTO l_stg_count FROM OKS_INT_COVERED_LEVEL_STG_TEMP;
4726: /* to avoid gscc failure */
4727: IF G_STMT_LOG THEN
4728: fnd_log.string(fnd_log.level_statement,
4729: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,