57: IF p_per_information2 IS NOT NULL THEN
58: BEGIN
59: select 1
60: into l_v
61: from dual where EXISTS
62: (SELECT NULL
63: FROM per_all_people_f
64: WHERE per_information2 = p_per_information2
65: AND business_group_id=p_business_group_id);
120: IF val_changed(p_per_information2) AND p_per_information2 IS NOT NULL THEN
121: BEGIN
122: select 1
123: into l_v
124: from dual where EXISTS
125: (SELECT NULL
126: FROM per_all_people_f
127: WHERE per_information2 = p_per_information2
128: AND person_id <> p_person_id