APPS.HR_PDC_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_contacts pdc
31: , hr_person_deployments pdt
32: where pdc.person_deplymt_contact_id = p_person_deplymt_contact_id
33: and pdc.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 275: hr_person_deployments pdt

271: --
272: cursor csr_check_person is
273: select ctr.person_id
274: from per_contact_relationships ctr,
275: hr_person_deployments pdt
276: where pdt.person_deployment_id = p_person_deployment_id
277: and ctr.contact_relationship_id = p_contact_relationship_id
278: and pdt.from_person_id = ctr.person_id;
279: --