APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on OKS_INT_SALES_CREDIT_STG_TEMP

Line 266: OKS_INT_SALES_CREDIT_STG_TEMP OSCST,

262: count(distinct ONI1.rowid) over (partition by OHST.INTERFACE_STATUS) NOTES1_COUNT,
263: count(distinct ONI2.rowid) over (partition by OHST.INTERFACE_STATUS) NOTES2_COUNT
264: FROM OKS_INT_HEADER_STG_TEMP OHST,
265: OKS_INT_LINE_STG_TEMP OLST,
266: OKS_INT_SALES_CREDIT_STG_TEMP OSCST,
267: OKS_INT_COVERED_LEVEL_STG_TEMP OCLST,
268: OKS_INT_USAGE_COUNTER_STG_TEMP OUCST,
269: OKS_NOTES_INTERFACE ONI1,
270: OKS_NOTES_INTERFACE ONI2

Line 355: DELETE FROM OKS_INT_SALES_CREDIT_STG_TEMP;

351: DELETE FROM OKS_COVERED_SYSTEM_STG_TEMP;
352: DELETE FROM OKS_INT_COVERED_LEVEL_STG_TEMP;
353: DELETE FROM OKS_INT_USAGE_COUNTER_STG_TEMP;
354: DELETE FROM OKS_INT_ERROR_STG_TEMP;
355: DELETE FROM OKS_INT_SALES_CREDIT_STG_TEMP;
356:
357: IF G_PROCEDURE_LOG THEN
358: fnd_log.string(fnd_log.level_procedure,
359: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,