94: cursor le_exists(p_person_id in number
95: ,p_ler_id in number
96: ,p_lf_evt_ocrd_dt in date) is
97: select 'Y'
98: from ben_ptnl_ler_for_per
99: where person_id = p_person_id
100: and ler_id = p_ler_id
101: and ptnl_ler_for_per_stat_cd = 'DTCTD'
102: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
365: if le_exists%notfound then
366: hr_utility.set_location(' Entering: ben_abv_trigger5', 60);
367:
368: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
369: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
370: (p_validate => false
371: ,p_ptnl_ler_for_per_id => l_ptnl_id
372: ,p_ntfn_dt => l_system_date
373: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date
392: if le_exists%notfound then
393: hr_utility.set_location(' Entering: ben_abv_trigger5', 60);
394:
395: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
396: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
397: (p_validate => false
398: ,p_ptnl_ler_for_per_id => l_ptnl_id
399: ,p_ntfn_dt => l_system_date
400: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date