APPS.HR_PDE_BUS dependencies on PER_PEOPLE_EXTRA_INFO

Line 238: -- PER_PEOPLE_EXTRA_INFO table

234: -- ---------------------------------------------------------------------------
235: --
236: -- Desciption:
237: -- This procedures validates that the person extra info id exists on the
238: -- PER_PEOPLE_EXTRA_INFO table
239: --
240: -- Pre-conditions :
241: -- None
242: --

Line 271: from per_people_extra_info

267: l_host_bg_leg varchar2(30);
268: --
269: cursor csr_extra_info is
270: select 1
271: from per_people_extra_info
272: where person_extra_info_id = p_person_extra_info_id;
273: --
274: cursor csr_check_person is
275: select pei.person_id

Line 276: from per_people_extra_info pei,

272: where person_extra_info_id = p_person_extra_info_id;
273: --
274: cursor csr_check_person is
275: select pei.person_id
276: from per_people_extra_info pei,
277: hr_person_deployments pdt
278: where pdt.person_deployment_id = p_person_deployment_id
279: and pei.person_extra_info_id = p_person_extra_info_id
280: and pdt.from_person_id = pei.person_id;

Line 285: per_people_extra_info pei

281: --
282: cursor csr_get_eit_leg is
283: select pit.legislation_code
284: from per_people_info_types pit,
285: per_people_extra_info pei
286: where pei.person_extra_info_id = p_person_extra_info_id
287: and pei.information_type = pit.information_type;
288: --
289: cursor csr_get_host_bg_leg is