APPS.BEN_DETERMINE_ELIGIBILITY3 dependencies on BEN_ELIG_PER_F

Line 362: from ben_elig_per_f

358: cursor c_upd_pep(v_elig_per_id number,
359: v_effective_date date,
360: v_per_in_ler_id number ) is
361: select *
362: from ben_elig_per_f
363: where elig_per_id = v_elig_per_id
364: and effective_start_date = v_effective_date
365: and nvl(per_in_ler_id , -1) = v_per_in_ler_id ;
366: --

Line 406: --BEN_ELIG_PER_F

402: END IF;
403: --
404: END IF;
405: --
406: --BEN_ELIG_PER_F
407: IF p_elig_per_id IS NOT NULL THEN
408: --
409: FOR l_upd_pep_rec IN c_upd_pep(p_elig_per_id,
410: p_effective_date,

Line 527: 'BEN_ELIG_PER_F_CORRECT',

523: PLIP_ORDR_NUM,
524: PTIP_ORDR_NUM )
525: values (
526: p_current_per_in_ler_id,
527: 'BEN_ELIG_PER_F_CORRECT',
528: l_upd_pep_rec.PLIP_ID,
529: l_upd_pep_rec.PTIP_ID,
530: l_upd_pep_rec.WAIT_PERD_CMPLTN_DT,
531: l_upd_pep_rec.PER_IN_LER_ID,

Line 639: --BEN_ELIG_PER_F

635: --
636: END LOOP;
637: END IF;
638: --
639: --BEN_ELIG_PER_F
640: IF p_elig_per_opt_id IS NOT NULL THEN
641: --
642: FOR l_upd_epo_rec IN c_upd_epo(p_elig_per_opt_id,
643: p_effective_date,