APPS.IRC_SEARCH_CRITERIA_VALUES_UPG dependencies on DUAL

Line 81: from dual where l_prof_area(i) is not null;

77: l_update_login(i),
78: l_created_by(i),
79: l_create_date(i),
80: 1
81: from dual where l_prof_area(i) is not null;
82: -- update IRC_LOCATION_CRITERIA_VALUES
83: FORALL i IN l_criteria_id.FIRST..l_criteria_id.LAST
84: insert into irc_location_criteria_values
85: (location_criteria_value_id

Line 104: from dual where l_location(i) is not null;

100: l_update_login(i),
101: l_created_by(i),
102: l_create_date(i),
103: 1
104: from dual where l_location(i) is not null;
105: --
106: update irc_search_criteria
107: set professional_area = null, derived_location = null
108: where search_criteria_id between p_start_pkid and p_end_pkid