DBA Data[Home] [Help]

APPS.BEN_CRT_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 84: from ben_ptnl_ler_for_per

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

Line 408: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

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

Line 435: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

431: if le_exists%notfound then
432: hr_utility.set_location(' Entering: ben_crt_trigger5', 60);
433:
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