APPS.BEN_POPULATE_RBV dependencies on BEN_ENRT_BNFT

Line 17: Type t_enb_tab is table of ben_enrt_bnft%rowtype index by binary_integer;

13: Type t_pel_tab is table of ben_pil_elctbl_chc_popl%rowtype index by binary_integer;
14: Type t_ecc_tab is table of ben_elctbl_chc_ctfn%rowtype index by binary_integer;
15: Type t_egd_tab is table of ben_elig_dpnt%rowtype index by binary_integer;
16: Type t_pdp_tab is table of ben_elig_cvrd_dpnt_f%rowtype index by binary_integer;
17: Type t_enb_tab is table of ben_enrt_bnft%rowtype index by binary_integer;
18: Type t_epr_tab is table of ben_enrt_prem%rowtype index by binary_integer;
19: Type t_ecr_tab is table of ben_enrt_rt%rowtype index by binary_integer;
20: Type t_prv_tab is table of ben_prtt_rt_val%rowtype index by binary_integer;
21: Type t_pen_tab is table of ben_prtt_enrt_rslt_f%rowtype index by binary_integer;

Line 1773: insert into ben_enrt_bnft_rbv

1769: --
1770: for elenum in p_enb_set.first ..p_enb_set.last
1771: loop
1772: --
1773: insert into ben_enrt_bnft_rbv
1774: (enrt_bnft_id
1775: ,dflt_flag
1776: ,val_has_bn_prortd_flag
1777: ,bndry_perd_cd

Line 3094: ben_enrt_bnft enb,

3090: and ecc.last_update_date > c_lu_dt
3091: union
3092: select ecc.*
3093: from ben_elctbl_chc_ctfn ecc,
3094: ben_enrt_bnft enb,
3095: ben_elig_per_elctbl_chc epe,
3096: ben_per_in_ler pil
3097: where pil.person_id = c_per_id
3098: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3130: ben_enrt_bnft enb,

3126: )
3127: is
3128: select ecc.*
3129: from ben_elctbl_chc_ctfn ecc,
3130: ben_enrt_bnft enb,
3131: ben_elig_per_elctbl_chc epe,
3132: ben_per_in_ler pil
3133: where pil.person_id = c_per_id
3134: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3190: from ben_enrt_bnft enb,

3186: ,c_lu_dt date
3187: )
3188: is
3189: select enb.*
3190: from ben_enrt_bnft enb,
3191: ben_elig_per_elctbl_chc epe,
3192: ben_per_in_ler pil
3193: where pil.person_id = c_per_id
3194: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3218: ben_enrt_bnft enb,

3214: between c_lu_dt and sysdate
3215: union
3216: select epr.*
3217: from ben_enrt_prem epr,
3218: ben_enrt_bnft enb,
3219: ben_elig_per_elctbl_chc epe,
3220: ben_per_in_ler pil
3221: where pil.person_id = c_per_id
3222: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3253: ben_enrt_bnft enb,

3249: )
3250: is
3251: select epr.*
3252: from ben_enrt_prem epr,
3253: ben_enrt_bnft enb,
3254: ben_elig_per_elctbl_chc epe,
3255: ben_per_in_ler pil
3256: where pil.person_id = c_per_id
3257: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3282: ben_enrt_bnft enb,

3278: between c_lu_dt and sysdate
3279: union
3280: select ecr.*
3281: from ben_enrt_rt ecr,
3282: ben_enrt_bnft enb,
3283: ben_elig_per_elctbl_chc epe,
3284: ben_per_in_ler pil
3285: where pil.person_id = c_per_id
3286: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3318: ben_enrt_bnft enb,

3314: )
3315: is
3316: select ecr.*
3317: from ben_enrt_rt ecr,
3318: ben_enrt_bnft enb,
3319: ben_elig_per_elctbl_chc epe,
3320: ben_per_in_ler pil
3321: where pil.person_id = c_per_id
3322: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3814: l_table_name := 'BEN_ENRT_BNFT_RBV';

3810: );
3811: --
3812: -- Coverage
3813: --
3814: l_table_name := 'BEN_ENRT_BNFT_RBV';
3815: l_elenum := 0;
3816: --
3817: for row in c_enbrbv
3818: (c_per_id => l_person_id