APPS.BEN_CEL_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 81: from ben_ptnl_ler_for_per

77: cursor le_exists(p_person_id in number
78: ,p_ler_id in number
79: ,p_lf_evt_ocrd_dt in date) is
80: select 'Y'
81: from ben_ptnl_ler_for_per
82: where person_id = p_person_id
83: and ler_id = p_ler_id
84: and ptnl_ler_for_per_stat_cd = 'DTCTD'
85: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 751: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

747: if le_exists%notfound then
748: hr_utility.set_location(' Entering: ben_cel_trigger5', 60);
749:
750: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
751: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
752: (p_validate => false
753: ,p_ptnl_ler_for_per_id => l_ptnl_id
754: ,p_ntfn_dt => trunc(sysdate)
755: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 778: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

774: if le_exists%notfound then
775: hr_utility.set_location(' Entering: ben_cel_trigger5', 60);
776:
777: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
778: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
779: (p_validate => false
780: ,p_ptnl_ler_for_per_id => l_ptnl_id
781: ,p_ntfn_dt => trunc(sysdate)
782: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date