APPS.HR_PDE_BUS dependencies on HR_PERSON_DEPLOYMENTS

Line 31: , hr_person_deployments pdt

27: cursor csr_leg_code is
28: select pbg.legislation_code
29: from per_business_groups_perf pbg
30: , hr_person_deplymt_eits pde
31: , hr_person_deployments pdt
32: where pde.person_deplymt_eit_id = p_person_deplymt_eit_id
33: and pde.person_deployment_id = pdt.person_deployment_id
34: and pbg.business_group_id = pdt.to_business_group_id;
35: --

Line 174: -- HR_PERSON_DEPLOYMENTS table

170: -- ---------------------------------------------------------------------------
171: --
172: -- Desciption:
173: -- This procedures validates that the person deployment id exists on the
174: -- HR_PERSON_DEPLOYMENTS table
175: --
176: -- Pre-conditions :
177: -- None
178: --

Line 204: from hr_person_deployments

200: l_dummy number;
201: --
202: cursor csr_deployment is
203: select 1
204: from hr_person_deployments
205: where person_deployment_id = p_person_deployment_id;
206: --
207: begin
208: hr_utility.set_location('Entering:'||l_proc, 10);

Line 277: hr_person_deployments pdt

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;
281: --

Line 291: from hr_person_deployments pdt,

287: and pei.information_type = pit.information_type;
288: --
289: cursor csr_get_host_bg_leg is
290: select legislation_code
291: from hr_person_deployments pdt,
292: per_business_groups_perf bg
293: where pdt.person_deployment_id = p_person_deployment_id
294: and pdt.to_business_group_id = bg.business_group_id;
295: --