APPS.BEN_POPULATE_RBV dependencies on BEN_ELCTBL_CHC_CTFN

Line 14: Type t_ecc_tab is table of ben_elctbl_chc_ctfn%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;
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;

Line 1253: insert into ben_elctbl_chc_ctfn_rbv

1249: --
1250: for elenum in p_ecc_set.first..p_ecc_set.last
1251: loop
1252: --
1253: insert into ben_elctbl_chc_ctfn_rbv
1254: ( elctbl_chc_ctfn_id,
1255: enrt_ctfn_typ_cd,
1256: rqd_flag,
1257: elig_per_elctbl_chc_id,

Line 3084: from ben_elctbl_chc_ctfn ecc,

3080: ,c_lu_dt date
3081: )
3082: is
3083: select ecc.*
3084: from ben_elctbl_chc_ctfn ecc,
3085: ben_elig_per_elctbl_chc epe,
3086: ben_per_in_ler pil
3087: where pil.person_id = c_per_id
3088: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3093: from ben_elctbl_chc_ctfn ecc,

3089: and epe.ELIG_PER_ELCTBL_CHC_ID = ecc.ELIG_PER_ELCTBL_CHC_ID
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

Line 3111: from ben_elctbl_chc_ctfn ecc,

3107: ,c_lu_dt date
3108: )
3109: is
3110: select ecc.*
3111: from ben_elctbl_chc_ctfn ecc,
3112: ben_elig_per_elctbl_chc epe,
3113: ben_per_in_ler pil
3114: where pil.person_id = c_per_id
3115: and epe.per_in_ler_id = pil.per_in_ler_id

Line 3129: from ben_elctbl_chc_ctfn ecc,

3125: ,c_lu_dt date
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

Line 3675: l_table_name := 'BEN_ELCTBL_CHC_CTFN_RBV';

3671: ,p_person_action_id => p_person_action_id
3672: ,p_pel_set => l_pel_set
3673: );
3674: --
3675: l_table_name := 'BEN_ELCTBL_CHC_CTFN_RBV';
3676: l_elenum := 0;
3677: --
3678: for row in c_eccrbv
3679: (c_per_id => l_person_id