DBA Data[Home] [Help]

APPS.BEN_ABV_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 98: from ben_ptnl_ler_for_per

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;

Line 369: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

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

Line 396: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

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