DBA Data[Home] [Help]

APPS.BEN_CON_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 107: from ben_ptnl_ler_for_per

103: cursor le_exists(p_person_id in number
104: ,p_ler_id in number
105: ,p_lf_evt_ocrd_dt in date) is
106: select 'Y'
107: from ben_ptnl_ler_for_per
108: where person_id = p_person_id
109: and ler_id = p_ler_id
110: and ptnl_ler_for_per_stat_cd = 'DTCTD'
111: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 946: ---ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

942: fetch le_exists into l_le_exists;
943: if le_exists%notfound then
944: hr_utility.set_location(l_proc, 96);
945: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
946: ---ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
947: (p_validate => false
948: ,p_ptnl_ler_for_per_id => l_ptnl_id
949: ,p_ntfn_dt => l_system_date
950: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 970: ---ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

966: if le_exists%notfound then
967: hr_utility.set_location(l_proc, 98);
968:
969: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
970: ---ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
971: (p_validate => false
972: ,p_ptnl_ler_for_per_id => l_ptnl_id
973: ,p_ntfn_dt => l_system_date
974: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date