APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_ENRT_RT

Line 393: ben_enrt_rt ecr

389: prv.prtt_rt_val_id
390: from ben_prtt_rt_val prv,
391: ben_elig_per_elctbl_chc epe,
392: ben_enrt_bnft enb,
393: ben_enrt_rt ecr
394: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
395: and prv.prtt_rt_val_stat_cd is null
396: and ecr.entr_val_at_enrt_flag = 'Y'
397: and ecr.prtt_rt_val_id = prv.prtt_rt_val_id

Line 406: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

402: and NVL(ecr.elig_per_elctbl_chc_id, epe.elig_per_elctbl_chc_id) = epe.elig_per_elctbl_chc_id
403: ;
404: --
405: type g_rt_rec is record
406: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
407: rt_val ben_enrt_rt.dflt_val%type,
408: ann_val ben_enrt_rt.ann_val%type,
409: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type
410: );

Line 407: rt_val ben_enrt_rt.dflt_val%type,

403: ;
404: --
405: type g_rt_rec is record
406: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
407: rt_val ben_enrt_rt.dflt_val%type,
408: ann_val ben_enrt_rt.ann_val%type,
409: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type
410: );
411: --

Line 408: ann_val ben_enrt_rt.ann_val%type,

404: --
405: type g_rt_rec is record
406: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
407: rt_val ben_enrt_rt.dflt_val%type,
408: ann_val ben_enrt_rt.ann_val%type,
409: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type
410: );
411: --
412: type g_rt_table is table of g_rt_rec index by binary_integer;

Line 409: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type

405: type g_rt_rec is record
406: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
407: rt_val ben_enrt_rt.dflt_val%type,
408: ann_val ben_enrt_rt.ann_val%type,
409: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type
410: );
411: --
412: type g_rt_table is table of g_rt_rec index by binary_integer;
413: l_rt_table g_rt_table;