DBA Data[Home] [Help]

APPS.BEN_PPS_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 85: from ben_ptnl_ler_for_per

81: cursor le_exists(p_person_id in number
82: ,p_ler_id in number
83: ,p_lf_evt_ocrd_dt in date) is
84: select 'Y'
85: from ben_ptnl_ler_for_per
86: where person_id = p_person_id
87: and ler_id = p_ler_id
88: and ptnl_ler_for_per_stat_cd = 'DTCTD'
89: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 555: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

551: if le_exists%notfound then
552: hr_utility.set_location(' Entering: ben_pps_trigger5', 60);
553:
554: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
555: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
556: (p_validate => false
557: ,p_ptnl_ler_for_per_id => l_ptnl_id
558: ,p_ntfn_dt => l_system_date
559: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date

Line 582: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

578: if le_exists%notfound then
579: hr_utility.set_location(' Entering: ben_pps_trigger5', 60);
580:
581: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
582: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
583: (p_validate => false
584: ,p_ptnl_ler_for_per_id => l_ptnl_id
585: ,p_ntfn_dt => l_system_date
586: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date