APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_ENRT_RT

Line 408: ben_enrt_rt ecr

404: prv.prtt_rt_val_id
405: from ben_prtt_rt_val prv,
406: ben_elig_per_elctbl_chc epe,
407: ben_enrt_bnft enb,
408: ben_enrt_rt ecr
409: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
410: and prv.prtt_rt_val_stat_cd is null
411: and ecr.entr_val_at_enrt_flag = 'Y'
412: and ecr.prtt_rt_val_id = prv.prtt_rt_val_id

Line 421: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

417: and NVL(ecr.elig_per_elctbl_chc_id, epe.elig_per_elctbl_chc_id) = epe.elig_per_elctbl_chc_id
418: ;
419: --
420: type g_rt_rec is record
421: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
422: rt_val ben_enrt_rt.dflt_val%type,
423: ann_val ben_enrt_rt.ann_val%type,
424: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type
425: );

Line 422: rt_val ben_enrt_rt.dflt_val%type,

418: ;
419: --
420: type g_rt_rec is record
421: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
422: rt_val ben_enrt_rt.dflt_val%type,
423: ann_val ben_enrt_rt.ann_val%type,
424: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type
425: );
426: --

Line 423: ann_val ben_enrt_rt.ann_val%type,

419: --
420: type g_rt_rec is record
421: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
422: rt_val ben_enrt_rt.dflt_val%type,
423: ann_val ben_enrt_rt.ann_val%type,
424: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type
425: );
426: --
427: type g_rt_table is table of g_rt_rec index by binary_integer;

Line 424: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type

420: type g_rt_rec is record
421: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
422: rt_val ben_enrt_rt.dflt_val%type,
423: ann_val ben_enrt_rt.ann_val%type,
424: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type
425: );
426: --
427: type g_rt_table is table of g_rt_rec index by binary_integer;
428: l_rt_table g_rt_table;