APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on PER_CONTACT_RELATIONSHIPS

Line 594: from per_contact_relationships pcr,

590: --
591: cursor get_contacts_pils(cv_person_id in number,
592: cv_csd_by_ptnl_ler_for_per_id in number) is
593: select pil.*
594: from per_contact_relationships pcr,
595: ben_per_in_ler pil,
596: ben_PTNL_LER_FOR_PER ppl
597: where --pcr.contact_person_id = cv_person_id
598: pcr.person_id = cv_person_id -- Bug 6620291

Line 619: from per_contact_relationships pcr,

615:
616: cursor get_fut_dtd_cntct_pils(cv_person_id in number
617: ) is
618: select pil.*
619: from per_contact_relationships pcr,
620: ben_per_in_ler pil,
621: ben_PTNL_LER_FOR_PER ppl
622: where pcr.contact_person_id = cv_person_id
623: and pcr.business_group_id = p_business_group_id

Line 637: per_contact_relationships pcr

633: cursor get_contacts_ptnls(cv_person_id in number,
634: cv_csd_by_ptnl_ler_for_per_id in number) is
635: select con_ppl.*
636: from ben_ptnl_ler_for_per con_ppl,
637: per_contact_relationships pcr
638: where con_ppl.csd_by_ptnl_ler_for_per_id = cv_csd_by_ptnl_ler_for_per_id
639: and con_ppl.PERSON_ID = pcr.person_id
640: and con_ppl.ptnl_ler_for_per_src_cd in ('SYSGND')
641: and pcr.contact_person_id = p_person_id;