APPS.HR_IT_EXTRA_PERSON_RULES dependencies on PER_ALL_PEOPLE_F

Line 63: FROM per_all_people_f

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);
66: if l_v = 1 then
67: hr_utility.set_message(800, 'HR_IT_INVALID_EMP_REF_NO');

Line 101: l_business_group_id per_all_people_f.business_group_id%TYPE;

97: -- Local variables.
98: --
99: l_v number(2) := 0;
100: l_per_information2 VARCHAR2(50);
101: l_business_group_id per_all_people_f.business_group_id%TYPE;
102: BEGIN
103: --
104: --
105: -- Uses tobacco cannot be entered.

Line 115: from per_all_people_f

111: --
112: --
113:
114: select distinct business_group_id into l_business_group_id
115: from per_all_people_f
116: where person_id=p_person_id;
117:
118: -- Employee Reference No must be unique.
119: --

Line 126: FROM per_all_people_f

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
129: AND business_group_id=l_business_group_id);
130: if l_v = 1 then