DBA Data[Home] [Help]

APPS.BEN_PAC_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 349: from ben_ptnl_ler_for_per

345: cursor le_exists(p_person_id in number
346: ,p_ler_id in number
347: ,p_lf_evt_ocrd_dt in date) is
348: select 'Y'
349: from ben_ptnl_ler_for_per
350: where person_id = p_person_id
351: and ler_id = p_ler_id
352: and ptnl_ler_for_per_stat_cd = 'DTCTD'
353: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 1123: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

1119: if le_exists%notfound then
1120: hr_utility.set_location(' Entering: ben_pac_trigger ', 60);
1121:
1122: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1123: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1124: (p_validate => false
1125: ,p_ptnl_ler_for_per_id => l_ptnl_id
1126: ,p_ntfn_dt => l_system_date
1127: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 1150: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

1146: if le_exists%notfound then
1147: hr_utility.set_location(' Entering: ben_pac_trigger5', 60);
1148:
1149: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1150: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1151: (p_validate => false
1152: ,p_ptnl_ler_for_per_id => l_ptnl_id
1153: ,p_ntfn_dt => l_system_date
1154: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date