DBA Data[Home] [Help]

APPS.BEN_POPULATE_RBV dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 13: Type t_pel_tab is table of ben_pil_elctbl_chc_popl%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;
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;

Line 3069: from ben_pil_elctbl_chc_popl pel,

3065: ,c_lu_dt date
3066: )
3067: is
3068: select pel.*
3069: from ben_pil_elctbl_chc_popl pel,
3070: ben_per_in_ler pil
3071: where pil.person_id = c_per_id
3072: and pel.per_in_ler_id = pil.per_in_ler_id
3073: and pel.last_update_date