APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_PTNL_LER_FOR_PER

Line 596: ben_PTNL_LER_FOR_PER ppl

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
599: and pcr.business_group_id = p_business_group_id
600: and pil.lf_evt_ocrd_dt between nvl(pcr.date_start,pil.lf_evt_ocrd_dt)

Line 621: ben_PTNL_LER_FOR_PER ppl

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
624: and pil.lf_evt_ocrd_dt > (Select pil1.lf_evt_ocrd_dt
625: from ben_per_in_ler pil1

Line 636: from ben_ptnl_ler_for_per con_ppl,

632:
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')

Line 669: /*ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

665: /*Bug 8495014: Potential LE's triggered on the dependent should not be backedout to VOID'ed state
666: while backing out the LifeEvent the on the Pariticipant.
667: Commented the call to 'update_ptnl_ler_for_per_perf' */
668:
669: /*ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
670: (p_validate => false
671: ,p_ptnl_ler_for_per_id => l_con_ptnls_rec.ptnl_ler_for_per_id
672: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
673: ,p_object_version_number => l_con_ptnls_rec.object_version_number

Line 770: from ben_ptnl_ler_for_per ppl

766: l_object_version_number number;
767: --
768: cursor c_ptnl is
769: select ppl.*
770: from ben_ptnl_ler_for_per ppl
771: where ppl.ptnl_ler_for_per_id = p_per_in_ler.ptnl_ler_for_per_id
772: and ppl.business_group_id = p_per_in_ler.business_group_id;
773: --
774: l_procd_ppl_rec c_ptnl%rowtype;

Line 788: from ben_ptnl_ler_for_per ppl

784: cv_ntfn_dt date,
785: cv_procd_ptnl_ler_for_per_id number)
786: is
787: select ppl.*
788: from ben_ptnl_ler_for_per ppl
789: where ppl.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
790: and ppl.business_group_id = cv_business_group_id
791: and ppl.ler_id = cv_ler_id
792: and ppl.ptnl_ler_for_per_id <> cv_procd_ptnl_ler_for_per_id

Line 848: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

844: --
845: end if;
846: --
847: hr_utility.set_location('Setting status to '||l_bckt_stat_cd,10);
848: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
849: (p_validate => false
850: ,p_ptnl_ler_for_per_id => p_per_in_ler.ptnl_ler_for_per_id
851: ,p_ptnl_ler_for_per_stat_cd => l_bckt_stat_cd
852: ,p_object_version_number => l_procd_ppl_rec.object_version_number