DBA Data[Home] [Help]

APPS.HR_IT_EXTRA_PERSON_RULES dependencies on DUAL

Line 61: from dual where EXISTS

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);

Line 124: from dual where EXISTS

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