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 532: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

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

Line 566: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

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