APPS.GHR_CREATE_PTNL_LIFE_EVENTS dependencies on BEN_PTNL_LER_FOR_PER

Line 83: select 1 from ben_ptnl_ler_for_per

79:
80: -- This name comparision could be replaced by the ler_short_code comparision once available.
81:
82: cursor c_chk_ptnl_ler is
83: select 1 from ben_ptnl_ler_for_per
84: where person_id = p_pa_request_rec.person_id
85: and lf_evt_ocrd_dt = p_pa_request_rec.effective_date
86: and ler_id = l_ler_id
87: and PTNL_LER_FOR_PER_STAT_CD = 'UNPROCD'

Line 431: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

427: exit;
428: end loop;
429: if l_ler_id is not null and l_ptnl_le_exists = 'N' then
430: hr_utility.set_location( l_proc,170 );
431: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
432: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
433: ,p_lf_evt_ocrd_dt => p_pa_request_rec.effective_date
434: ,p_ptnl_ler_for_per_stat_cd => 'UNPROCD'
435: ,p_ler_id => l_ler_id