APPS.OKS_IMPORT_VALIDATE dependencies on OKS_INT_SALES_CREDIT_STG_TEMP

Line 5193: INTO OKS_INT_SALES_CREDIT_STG_TEMP

5189: l_stmt_num := 10;
5190:
5191: INSERT ALL
5192: WHEN (1=1) THEN
5193: INTO OKS_INT_SALES_CREDIT_STG_TEMP
5194: (SALES_CREDIT_INTERFACE_ID
5195: ,HEADER_INTERFACE_ID
5196: ,HEADER_INTERFACE_ROWID
5197: ,SALESPERSON_ID

Line 5356: SELECT count(1) INTO l_stg_count FROM OKS_INT_SALES_CREDIT_STG_TEMP;

5352: SELECT count(1) INTO l_int_count FROM OKS_SALES_CREDITS_INTERFACE OSCI
5353: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5354: WHERE HEADER_INTERFACE_ID = OSCI.HEADER_INTERFACE_ID);
5355:
5356: SELECT count(1) INTO l_stg_count FROM OKS_INT_SALES_CREDIT_STG_TEMP;
5357:
5358: fnd_log.string(fnd_log.level_statement,
5359: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5360: 'Number of records in interface table being processed = ' || l_int_count ||', '||