DBA Data[Home] [Help]

APPS.BEN_PRV_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 101: from ben_ptnl_ler_for_per

97: cursor le_exists(p_person_id in number
98: ,p_ler_id in number
99: ,p_lf_evt_ocrd_dt in date) is
100: select 'Y'
101: from ben_ptnl_ler_for_per
102: where person_id = p_person_id
103: and ler_id = p_ler_id
104: and ptnl_ler_for_per_stat_cd = 'DTCTD'
105: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 548: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

544: fnd_message.set_name('BEN','BEN_92299_CANNOT_CREATE_PIL');
545: fnd_message.raise_error;
546: end if;
547: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
548: -- ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
549: (p_validate => false
550: ,p_ptnl_ler_for_per_id => l_ptnl_id
551: ,p_ntfn_dt => l_system_date
552: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 579: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

575: fnd_message.set_name('BEN','BEN_92299_CANNOT_CREATE_PIL');
576: fnd_message.raise_error;
577: end if;
578: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
579: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
580: (p_validate => false
581: ,p_ptnl_ler_for_per_id => l_ptnl_id
582: ,p_ntfn_dt => l_system_date
583: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date