APPS.BEN_ASG_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 88: from ben_ptnl_ler_for_per

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

Line 1023: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

1019: fetch le_exists into l_le_exists;
1020: if le_exists%notfound then
1021: hr_utility.set_location(' Entering: ben_asg_trigger5', 60);
1022: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1023: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1024: (p_validate => false
1025: ,p_ptnl_ler_for_per_id => l_ptnl_id
1026: ,p_ntfn_dt => l_system_date
1027: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 1051: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

1047: if le_exists%notfound then
1048: hr_utility.set_location(' Entering: ben_asg_trigger5', 60);
1049:
1050: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1051: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1052: (p_validate => false
1053: ,p_ptnl_ler_for_per_id => l_ptnl_id
1054: ,p_ntfn_dt => l_system_date
1055: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date