APPS.OKS_IMPORT_VALIDATE dependencies on OKS_INT_COVERED_LEVEL_STG_TEMP

Line 4077: INTO OKS_INT_COVERED_LEVEL_STG_TEMP

4073: l_stmt_num := 70;
4074:
4075: INSERT ALL
4076: WHEN (1=1) THEN
4077: INTO OKS_INT_COVERED_LEVEL_STG_TEMP
4078: (COVERED_LEVEL_INTERFACE_ID
4079: ,LINE_INTERFACE_ID
4080: ,HEADER_INTERFACE_ID
4081: ,COVERED_INSTANCE_ID

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

4595: SELECT count(1) INTO l_int_count FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4596: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
4597: WHERE LINE_INTERFACE_ID = OCLI.LINE_INTERFACE_ID);
4598:
4599: SELECT count(1) INTO l_stg_count FROM OKS_INT_COVERED_LEVEL_STG_TEMP;
4600: /* to avoid gscc failure */
4601: IF G_STMT_LOG THEN
4602: fnd_log.string(fnd_log.level_statement,
4603: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,