DBA Data[Home] [Help]

APPS.BEN_PPF_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 106: from ben_ptnl_ler_for_per

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

Line 1022: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

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

Line 1055: ---ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

1051: if le_exists%notfound then
1052: hr_utility.set_location(' Entering: ben_ppf_trigger5', 60);
1053:
1054: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1055: ---ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1056: (p_validate => false
1057: ,p_ptnl_ler_for_per_id => l_ptnl_id
1058: ,p_ntfn_dt => l_system_date
1059: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date