DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELIGIBILITY3 dependencies on BEN_ELIG_PER_OPT_F

Line 371: from ben_elig_per_opt_f

367: cursor c_upd_epo(v_elig_per_opt_id number,
368: v_effective_date date,
369: v_per_in_ler_id number ) is
370: select *
371: from ben_elig_per_opt_f
372: where elig_per_opt_id = v_elig_per_opt_id
373: and nvl(per_in_ler_id , -1) = v_per_in_ler_id
374: and effective_start_date = v_effective_date;
375: --

Line 746: 'BEN_ELIG_PER_OPT_F_CORRECT',

742: OIPL_ORDR_NUM,
743: PRTN_END_DT )
744: values (
745: p_current_per_in_ler_id,
746: 'BEN_ELIG_PER_OPT_F_CORRECT',
747: l_upd_epo_rec.INELG_RSN_CD,
748: l_upd_epo_rec.PER_IN_LER_ID,
749: l_upd_epo_rec.AGE_UOM,
750: l_upd_epo_rec.LOS_UOM,