DBA Data[Home] [Help]

APPS.BEN_EEV_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 91: from ben_ptnl_ler_for_per

87: cursor le_exists(p_person_id in number
88: ,p_ler_id in number
89: ,p_lf_evt_ocrd_dt in date) is
90: select 'Y'
91: from ben_ptnl_ler_for_per
92: where person_id = p_person_id
93: and ler_id = p_ler_id
94: and ptnl_ler_for_per_stat_cd = 'DTCTD'
95: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 295: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

291: if le_exists%notfound then
292: hr_utility.set_location(' Entering: ben_eev_trigger5', 60);
293:
294: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
295: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
296: (p_validate => false
297: ,p_ptnl_ler_for_per_id => l_ptnl_id
298: ,p_ntfn_dt => l_system_date
299: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 321: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

317: fetch le_exists into l_le_exists;
318: if le_exists%notfound then
319: hr_utility.set_location(' Entering: ben_eev_trigger5', 60);
320: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
321: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
322: (p_validate => false
323: ,p_ptnl_ler_for_per_id => l_ptnl_id
324: ,p_ntfn_dt => l_system_date
325: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date