APPS.BEN_POPULATE_RBV dependencies on BEN_ELIG_PER_OPT_F

Line 11: Type t_epo_tab is table of ben_elig_per_opt_f%rowtype index by binary_integer;

7: Type t_pil_tab is table of ben_per_in_ler%rowtype index by binary_integer;
8: Type t_crp_tab is table of ben_cbr_per_in_ler%rowtype index by binary_integer;
9: Type t_cqb_tab is table of ben_cbr_quald_bnf%rowtype index by binary_integer;
10: Type t_pep_tab is table of ben_elig_per_f%rowtype index by binary_integer;
11: Type t_epo_tab is table of ben_elig_per_opt_f%rowtype index by binary_integer;
12: Type t_epe_tab is table of ben_elig_per_elctbl_chc%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;

Line 630: insert into ben_elig_per_opt_f_rbv

626: --
627: for elenum in p_epo_set.first ..p_epo_set.last
628: loop
629: --
630: insert into ben_elig_per_opt_f_rbv
631: ( elig_per_opt_id,
632: elig_per_id,
633: effective_start_date,
634: effective_end_date,

Line 3020: from ben_elig_per_opt_f epo,

3016: ,c_lu_dt date
3017: )
3018: is
3019: select epo.*
3020: from ben_elig_per_opt_f epo,
3021: ben_elig_per_f pep
3022: where pep.person_id = c_per_id
3023: and pep.elig_per_id = epo.elig_per_id
3024: and epo.effective_start_date

Line 3040: from ben_elig_per_opt_f epo,

3036: ,c_lu_dt date
3037: )
3038: is
3039: select epo.*
3040: from ben_elig_per_opt_f epo,
3041: ben_per_in_ler pil
3042: where pil.person_id = c_per_id
3043: and pil.per_in_ler_id = epo.per_in_ler_id
3044: and epo.last_update_date

Line 3559: l_table_name := 'BEN_ELIG_PER_OPT_F_RBV';

3555: ,p_person_action_id => p_person_action_id
3556: ,p_pep_set => l_pep_set
3557: );
3558: --
3559: l_table_name := 'BEN_ELIG_PER_OPT_F_RBV';
3560: l_elenum := 0;
3561: --
3562: if l_bftdets.mode_cd = 'S'
3563: then