DBA Data[Home] [Help]

APPS.BEN_PPR_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 92: from ben_ptnl_ler_for_per

88: cursor le_exists(p_person_id in number
89: ,p_ler_id in number
90: ,p_lf_evt_ocrd_dt in date) is
91: select 'Y'
92: from ben_ptnl_ler_for_per
93: where person_id = p_person_id
94: and ler_id = p_ler_id
95: and ptnl_ler_for_per_stat_cd = 'DTCTD'
96: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 900: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

896:
897: if le_exists%notfound then
898: hr_utility.set_location(' Entering: ben_ppr_trigger5', 60);
899: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
900: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
901: (p_validate => false
902: ,p_ptnl_ler_for_per_id => l_ptnl_id
903: ,p_ntfn_dt => trunc(sysdate)
904: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 932: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

928: -- create it.
929: if le_exists%notfound then
930: hr_utility.set_location(' Entering: ben_ppr_trigger5', 60);
931: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
932: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
933: (p_validate => false
934: ,p_ptnl_ler_for_per_id => l_ptnl_id
935: ,p_ntfn_dt => trunc(sysdate)
936: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date