APPS.BEN_POPULATE_RBV dependencies on BEN_ELIG_PER_F

Line 10: Type t_pep_tab is table of ben_elig_per_f%rowtype index by binary_integer;

6: Type t_ppl_tab is table of ben_ptnl_ler_for_per%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;

Line 383: insert into ben_elig_per_f_rbv

379: --
380: for elenum in p_pep_set.first ..p_pep_set.last
381: loop
382: --
383: insert into ben_elig_per_f_rbv
384: (
385: elig_per_id,
386: effective_start_date,
387: effective_end_date,

Line 3008: from ben_elig_per_f pep

3004: ,c_lu_dt date
3005: )
3006: is
3007: select pep.*
3008: from ben_elig_per_f pep
3009: where pep.person_id = c_per_id
3010: and pep.last_update_date
3011: between c_lu_dt and sysdate
3012: order by pep.elig_per_id;

Line 3021: ben_elig_per_f pep

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
3025: between pep.effective_start_date and pep.effective_end_date

Line 3526: l_table_name := 'BEN_ELIG_PER_F_RBV';

3522: ,p_person_action_id => p_person_action_id
3523: ,p_crp_set => l_crp_set
3524: );
3525: --
3526: l_table_name := 'BEN_ELIG_PER_F_RBV';
3527: l_elenum := 0;
3528: --
3529: for row in c_peprbv
3530: (c_per_id => l_person_id