APPS.IGS_EN_DROP_UNITS_API dependencies on IGS_AD_ADM_UNIT_STAT

Line 1230: l_description igs_ad_adm_unit_stat.description%TYPE;

1226:
1227: TYPE c_ref_cur_typ IS REF CURSOR;
1228: c_ref_cur c_ref_cur_typ;
1229:
1230: l_description igs_ad_adm_unit_stat.description%TYPE;
1231:
1232: BEGIN
1233: l_token_desc := NULL;
1234: l_token := '''' || REPLACE (p_token, ',',''',''') || '''';

Line 1237: FROM igs_ad_adm_unit_stat_v

1233: l_token_desc := NULL;
1234: l_token := '''' || REPLACE (p_token, ',',''',''') || '''';
1235:
1236: l_stmt := 'SELECT description
1237: FROM igs_ad_adm_unit_stat_v
1238: WHERE unit_attempt_status = ''DISCONTIN''
1239: AND closed_ind = ''N''
1240: AND administrative_unit_status IN (' || l_token || ')';
1241: