APPS.OKS_IMPORT_VALIDATE dependencies on OKS_INT_USAGE_COUNTER_STG_TEMP

Line 4773: INTO OKS_INT_USAGE_COUNTER_STG_TEMP

4769:
4770: l_stmt_num := 10;
4771: INSERT ALL
4772: WHEN (1=1) THEN
4773: INTO OKS_INT_USAGE_COUNTER_STG_TEMP
4774: (USAGE_COUNTER_INTERFACE_ID
4775: ,LINE_INTERFACE_ID
4776: ,HEADER_INTERFACE_ROWID
4777: ,LINE_INTERFACE_ROWID

Line 5266: SELECT count(1) INTO l_int_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUCI

5262:
5263:
5264: IF G_STMT_LOG THEN
5265:
5266: SELECT count(1) INTO l_int_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUCI
5267: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5268: WHERE LINE_INTERFACE_ID = OUCI.LINE_INTERFACE_ID);
5269:
5270: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;

Line 5270: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;

5266: SELECT count(1) INTO l_int_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUCI
5267: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5268: WHERE LINE_INTERFACE_ID = OUCI.LINE_INTERFACE_ID);
5269:
5270: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;
5271: /* to avoid gscc failure */
5272: IF G_STMT_LOG THEN
5273: fnd_log.string(fnd_log.level_statement,
5274: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,