APPS.WIP_WICTPG dependencies on CST_PERIOD_VALUE_TEMP

Line 1468: x_purge_rec.table_name := 'CST_PERIOD_VALUE_TEMP';

1464: end if;
1465:
1466: x_purge_rec.info_type := ROWS_AFFECTED;
1467:
1468: x_purge_rec.table_name := 'CST_PERIOD_VALUE_TEMP';
1469:
1470:
1471: if (p_option = REPORT_ONLY) then
1472: SELECT COUNT(*) INTO x_num_rows

Line 1473: FROM CST_PERIOD_VALUE_TEMP

1469:
1470:
1471: if (p_option = REPORT_ONLY) then
1472: SELECT COUNT(*) INTO x_num_rows
1473: FROM CST_PERIOD_VALUE_TEMP
1474: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1475: AND ORGANIZATION_ID = x_purge_rec.org_id;
1476: else
1477: DELETE FROM CST_PERIOD_VALUE_TEMP

Line 1477: DELETE FROM CST_PERIOD_VALUE_TEMP

1473: FROM CST_PERIOD_VALUE_TEMP
1474: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1475: AND ORGANIZATION_ID = x_purge_rec.org_id;
1476: else
1477: DELETE FROM CST_PERIOD_VALUE_TEMP
1478: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1479: AND ORGANIZATION_ID = x_purge_rec.org_id;
1480:
1481: x_num_rows := SQL%ROWCOUNT ;