DBA Data[Home] [Help]

APPS.BEN_ECD_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 95: from ben_ptnl_ler_for_per

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

Line 535: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

531: fnd_message.set_name('BEN','BEN_92299_CANNOT_CREATE_PIL');
532: fnd_message.raise_error;
533: end if;
534: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
535: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
536: (p_validate => false
537: ,p_ptnl_ler_for_per_id => l_ptnl_id
538: ,p_ntfn_dt => l_system_date
539: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 569: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

565: fnd_message.set_name('BEN','BEN_92299_CANNOT_CREATE_PIL');
566: fnd_message.raise_error;
567: end if;
568:
569: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
570: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
571: (p_validate => false
572: ,p_ptnl_ler_for_per_id => l_ptnl_id
573: ,p_ntfn_dt => l_system_date