APPS.IRC_RTM_BUS dependencies on PER_ALL_PEOPLE_F

Line 160: -- Validates if the person id exists in the PER_ALL_PEOPLE_F table

156: -- |---------------------------< chk_person_id >-------------------------------|
157: -- ----------------------------------------------------------------------------
158: --
159: -- Description:
160: -- Validates if the person id exists in the PER_ALL_PEOPLE_F table
161: --
162: -- Prerequisites:
163: -- Must be called as the first step in insert_validate.
164: --

Line 169: -- If the person_id is existing in PER_ALL_PEOPLE_F

165: -- In Arguments:
166: -- p_person_id
167: --
168: -- Post Success:
169: -- If the person_id is existing in PER_ALL_PEOPLE_F
170: -- then continue.
171: --
172: -- Post Failure:
173: -- If the person_id is not present in PER_ALL_PEOPLE_F

Line 173: -- If the person_id is not present in PER_ALL_PEOPLE_F

169: -- If the person_id is existing in PER_ALL_PEOPLE_F
170: -- then continue.
171: --
172: -- Post Failure:
173: -- If the person_id is not present in PER_ALL_PEOPLE_F
174: -- then throw an error indicating the same.
175: --
176: -- Access Status:
177: -- Internal Row Handler Use Only.

Line 192: from per_all_people_f

188: l_var varchar2(1);
189: --
190: cursor l_person is
191: select party_id
192: from per_all_people_f
193: where person_id = p_person_id
194: and p_effective_date between
195: effective_start_date and effective_end_date;
196: --

Line 201: FROM per_all_people_f paf

197:
198:
199: cursor csr_system_person_type is
200: SELECT NULL
201: FROM per_all_people_f paf
202: WHERE paf.person_id = p_person_id
203: AND p_effective_date BETWEEN paf.effective_start_date
204: AND paf.effective_end_date
205: AND ( NVL (paf.current_employee_flag, 'N') = 'Y'