APPS.IRC_SEARCH_CRITERIA_VALUES_UPG dependencies on IRC_PROF_AREA_CRITERIA_VALUES

Line 59: -- update IRC_PROF_AREA_CRITERIA_VALUES

55: p_rows_processed := l_criteria_id.COUNT;
56: CLOSE cur_upd_search_criteria;
57: --
58: IF l_criteria_id.FIRST is not null THEN
59: -- update IRC_PROF_AREA_CRITERIA_VALUES
60: FORALL i IN l_criteria_id.FIRST..l_criteria_id.LAST
61: insert into irc_prof_area_criteria_values
62: (prof_area_criteria_value_id
63: ,search_criteria_id

Line 61: insert into irc_prof_area_criteria_values

57: --
58: IF l_criteria_id.FIRST is not null THEN
59: -- update IRC_PROF_AREA_CRITERIA_VALUES
60: FORALL i IN l_criteria_id.FIRST..l_criteria_id.LAST
61: insert into irc_prof_area_criteria_values
62: (prof_area_criteria_value_id
63: ,search_criteria_id
64: ,professional_area
65: ,last_update_date