APPS.BEN_POPULATE_RBV dependencies on BEN_ELIG_CVRD_DPNT_F

Line 16: Type t_pdp_tab is table of ben_elig_cvrd_dpnt_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;
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;

Line 1505: insert into ben_elig_cvrd_dpnt_f_rbv

1501: --
1502: for elenum in p_pdp_set.first ..p_pdp_set.last
1503: loop
1504: --
1505: insert into ben_elig_cvrd_dpnt_f_rbv
1506: ( elig_cvrd_dpnt_id,
1507: effective_start_date,
1508: effective_end_date,
1509: business_group_id,

Line 3164: from ben_elig_cvrd_dpnt_f pdp,

3160: ,c_lu_dt date
3161: )
3162: is
3163: select pdp.*
3164: from ben_elig_cvrd_dpnt_f pdp,
3165: ben_per_in_ler pil
3166: where pil.person_id = c_per_id
3167: and pdp.per_in_ler_id = pil.per_in_ler_id
3168: and pdp.last_update_date