DBA Data[Home] [Help]

APPS.BEN_PEN_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 87: from ben_ptnl_ler_for_per

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

Line 401: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

397: if le_exists%notfound then
398: hr_utility.set_location(' Entering: ben_pen_trigger5', 60);
399:
400: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
401: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
402: (p_validate => false
403: ,p_ptnl_ler_for_per_id => l_ptnl_id
404: ,p_ntfn_dt => l_system_date
405: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 427: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

423: fetch le_exists into l_le_exists;
424: if le_exists%notfound then
425: hr_utility.set_location(' Entering: ben_pen_trigger5', 60);
426: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
427: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
428: (p_validate => false
429: ,p_ptnl_ler_for_per_id => l_ptnl_id
430: ,p_ntfn_dt => l_system_date
431: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date