APPS.BEN_COLLAPSE_LIFE_EVENT dependencies on BEN_PTNL_LER_FOR_PER

Line 36: from ben_ptnl_ler_for_per ptn,

32: ptn.ptnl_ler_for_per_stat_cd,
33: ptn.lf_evt_ocrd_dt,
34: ptn.ntfn_dt,
35: ptn.object_version_number
36: from ben_ptnl_ler_for_per ptn,
37: ben_ler_f ler
38: where ptn.business_group_id = p_business_group_id
39: and ptn.person_id = p_person_id
40: and ptn.ler_id = ler.ler_id

Line 521: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

517: elsif l_operation = 'V' then
518: --
519: -- Update the life event and set its status to voided
520: --
521: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
522: (p_ptnl_ler_for_per_id => g_included_events(l_count).
523: ptnl_ler_for_per_id,
524: p_ptnl_ler_for_per_stat_cd => 'VOIDD',
525: p_voidd_dt => p_effective_date,

Line 540: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per

536: benutils.write(fnd_message.get);
537: --
538: elsif l_operation = 'D' then
539: --
540: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per
541: (p_ptnl_ler_for_per_id => g_included_events(l_count).
542: ptnl_ler_for_per_id,
543: p_effective_date => p_effective_date,
544: p_object_version_number => g_included_events(l_count).

Line 563: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

559: end loop;
560: --
561: -- Now lets create the new collapsed life event
562: --
563: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
564: (p_validate => false,
565: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
566: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
567: p_ptnl_ler_for_per_stat_cd => 'DTCTD',