DBA Data[Home] [Help]

APPS.BEN_EGD_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 103: FROM ben_ptnl_ler_for_per bp

99: p_person_id IN per_all_people_f.person_id%TYPE,
100: p_ler_id IN ben_ler_f.ler_id%TYPE,
101: p_lf_evt_ocrd_dt IN DATE) IS
102: SELECT 'Y'
103: FROM ben_ptnl_ler_for_per bp
104: WHERE bp.person_id = p_person_id
105: AND bp.ler_id = p_ler_id
106: AND bp.ptnl_ler_for_per_stat_cd = 'DTCTD'
107: AND bp.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 641: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per(

637: IF le_exists%NOTFOUND THEN
638: hr_utility.set_location(' Entering: ben_egd_trigger5', 60);
639:
640: ben_create_ptnl_ler_for_per.create_ptnl_ler_event(
641: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per(
642: p_validate => FALSE,
643: p_ptnl_ler_for_per_id => l_ptnl_id,
644: p_ntfn_dt => l_system_date,
645: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date,

Line 673: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per(

669: IF le_exists%NOTFOUND THEN
670: hr_utility.set_location(' Entering: ben_egd_trigger5', 60);
671:
672: ben_create_ptnl_ler_for_per.create_ptnl_ler_event(
673: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per(
674: p_validate => FALSE,
675: p_ptnl_ler_for_per_id => l_ptnl_id,
676: p_ntfn_dt => l_system_date,
677: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date,