DBA Data[Home] [Help]

APPS.BEN_PTU_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 97: from ben_ptnl_ler_for_per

93: cursor le_exists(p_person_id in number
94: ,p_ler_id in number
95: ,p_lf_evt_ocrd_dt in date) is
96: select 'Y'
97: from ben_ptnl_ler_for_per
98: where person_id = p_person_id
99: and ler_id = p_ler_id
100: and ptnl_ler_for_per_stat_cd = 'DTCTD'
101: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 409: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

405: if le_exists%notfound then
406: hr_utility.set_location(' Entering: ben_ptu_trigger5', 60);
407:
408: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
409: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
410: (p_validate => false
411: ,p_ptnl_ler_for_per_id => l_ptnl_id
412: ,p_ntfn_dt => l_system_date
413: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 435: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

431: fetch le_exists into l_le_exists;
432: if le_exists%notfound then
433: hr_utility.set_location(' Entering: ben_ptu_trigger5', 60);
434: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
435: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
436: (p_validate => false
437: ,p_ptnl_ler_for_per_id => l_ptnl_id
438: ,p_ntfn_dt => l_system_date
439: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date