APPS.HR_PDC_BUS dependencies on PER_CONTACT_RELATIONSHIPS

Line 238: -- PER_CONTACT_RELATIONSHIPS table

234: -- ---------------------------------------------------------------------------
235: --
236: -- Desciption:
237: -- This procedures validates that the personcontact relationship id exists on the
238: -- PER_CONTACT_RELATIONSHIPS table
239: --
240: -- Pre-conditions :
241: -- None
242: --

Line 269: from per_contact_relationships

265: l_dummy number;
266: --
267: cursor csr_contact_rel is
268: select 1
269: from per_contact_relationships
270: where contact_relationship_id = p_contact_relationship_id;
271: --
272: cursor csr_check_person is
273: select ctr.person_id

Line 274: from per_contact_relationships ctr,

270: where contact_relationship_id = p_contact_relationship_id;
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;