APPS.HR_PDC_BUS dependencies on HR_PERSON_DEPLYMT_CONTACTS

Line 30: , hr_person_deplymt_contacts pdc

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

Line 260: (p_contact_relationship_id in hr_person_deplymt_contacts.contact_relationship_id%type

256: -- {End of Comments}
257: --
258: -- ---------------------------------------------------------------------------
259: Procedure chk_contact_relationship_id
260: (p_contact_relationship_id in hr_person_deplymt_contacts.contact_relationship_id%type
261: ,p_person_deployment_id in hr_person_deplymt_contacts.person_deployment_id%type
262: ) is
263: --
264: l_proc varchar2(72) := g_package||'chk_person_extra_info_id';

Line 261: ,p_person_deployment_id in hr_person_deplymt_contacts.person_deployment_id%type

257: --
258: -- ---------------------------------------------------------------------------
259: Procedure chk_contact_relationship_id
260: (p_contact_relationship_id in hr_person_deplymt_contacts.contact_relationship_id%type
261: ,p_person_deployment_id in hr_person_deplymt_contacts.person_deployment_id%type
262: ) is
263: --
264: l_proc varchar2(72) := g_package||'chk_person_extra_info_id';
265: l_dummy number;