DBA Data[Home] [Help]

APPS.BEN_QUA_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 830: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

826: if le_exists%notfound then
827: --
828: hr_utility.set_location(' Entering: ben_qua_trigger5', 60);
829: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
830: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
831: (p_validate => false
832: ,p_ptnl_ler_for_per_id => l_ptnl_id
833: ,p_ntfn_dt => trunc(sysdate)
834: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 863: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

859: if le_exists%notfound then
860: hr_utility.set_location(' Entering: ben_qua_trigger5', 60);
861:
862: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
863: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
864: (p_validate => false
865: ,p_ptnl_ler_for_per_id => l_ptnl_id
866: ,p_ntfn_dt => trunc(sysdate)
867: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date