DBA Data[Home] [Help]

APPS.CSF_RMDUP dependencies on CSF_MD_POI_NM_ASGNS

Line 360: from csf_md_poi_nm_asgns

356: procedure clean_poi_names
357: is
358: cursor c1( start_id NUMBER ) is
359: select poi_nm_asgn_id, rowid
360: from csf_md_poi_nm_asgns
361: where poi_nm_asgn_id >= start_id
362: order by poi_nm_asgn_id;
363: r1 c1%ROWTYPE;
364:

Line 384: delete from csf_md_poi_nm_asgns where rowid = r1.rowid;

380: exit;
381: end if;
382:
383: if ( min_start_id = r1.poi_nm_asgn_id ) then
384: delete from csf_md_poi_nm_asgns where rowid = r1.rowid;
385: else
386: min_start_id := r1.poi_nm_asgn_id;
387: end if;
388: