APPS.BEN_POPULATE_RBV dependencies on BEN_ELIG_DPNT

Line 15: Type t_egd_tab is table of ben_elig_dpnt%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;
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;

Line 1370: insert into ben_elig_dpnt_rbv

1366: --
1367: for elenum in p_egd_set.first ..p_egd_set.last
1368: loop
1369: --
1370: insert into ben_elig_dpnt_rbv
1371: ( elig_dpnt_id,
1372: create_dt,
1373: elig_strt_dt,
1374: elig_thru_dt,

Line 3150: from ben_elig_dpnt egd,

3146: ,c_lu_dt date
3147: )
3148: is
3149: select egd.*
3150: from ben_elig_dpnt egd,
3151: ben_per_in_ler pil
3152: where pil.person_id = c_per_id
3153: and egd.per_in_ler_id = pil.per_in_ler_id
3154: and egd.last_update_date

Line 3734: l_table_name := 'BEN_ELIG_DPNT_RBV';

3730: );
3731: --
3732: -- Dependent eligibility
3733: --
3734: l_table_name := 'BEN_ELIG_DPNT_RBV';
3735: l_elenum := 0;
3736: --
3737: for row in c_egdrbv
3738: (c_per_id => l_person_id