DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 512: g_enrt_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;

508: g_enrt_int_pl_name ben_pl_f.name%TYPE;
509: g_enrt_int_opt_id ben_opt_f.opt_id%TYPE;
510: g_enrt_int_opt_name ben_opt_f.name%TYPE;
511: g_enrt_int_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
512: g_enrt_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;
513: g_enrt_pl_fd_name ben_pl_f.short_name%Type ;
514: g_enrt_pl_fd_code ben_pl_f.short_code%Type ;
515: g_enrt_pgm_fd_name ben_pgm_f.short_name%Type ;
516: g_enrt_pgm_fd_code ben_pgm_f.short_code%Type ;

Line 788: g_elig_enrt_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%TYPE;

784: --
785: -- eligiblitity
786: --
787: g_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
788: g_elig_enrt_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%TYPE;
789: g_elig_enrt_end_dt ben_pil_elctbl_chc_popl.enrt_perd_end_dt%TYPE;
790: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;
791: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;
792: g_elig_pl_name ben_pl_f.name%TYPE;

Line 789: g_elig_enrt_end_dt ben_pil_elctbl_chc_popl.enrt_perd_end_dt%TYPE;

785: -- eligiblitity
786: --
787: g_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
788: g_elig_enrt_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%TYPE;
789: g_elig_enrt_end_dt ben_pil_elctbl_chc_popl.enrt_perd_end_dt%TYPE;
790: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;
791: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;
792: g_elig_pl_name ben_pl_f.name%TYPE;
793: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;

Line 790: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;

786: --
787: g_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
788: g_elig_enrt_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%TYPE;
789: g_elig_enrt_end_dt ben_pil_elctbl_chc_popl.enrt_perd_end_dt%TYPE;
790: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;
791: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;
792: g_elig_pl_name ben_pl_f.name%TYPE;
793: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
794: g_elig_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;

Line 791: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;

787: g_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
788: g_elig_enrt_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%TYPE;
789: g_elig_enrt_end_dt ben_pil_elctbl_chc_popl.enrt_perd_end_dt%TYPE;
790: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;
791: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;
792: g_elig_pl_name ben_pl_f.name%TYPE;
793: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
794: g_elig_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
795: g_elig_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;

Line 835: g_elig_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;

831: g_elig_er_ttl_cost ben_enrt_rt.val%TYPE;
832: g_elig_ee_ttl_distribution ben_enrt_rt.val%TYPE;
833: g_elig_er_ttl_distribution ben_enrt_rt.val%TYPE;
834: g_elig_ttl_other_rate ben_enrt_rt.val%TYPE;
835: g_elig_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;
836: g_elig_program_id ben_pgm_f.pgm_id%TYPE;
837: g_elig_program_name ben_pgm_f.name%TYPE;
838: g_elig_total_premium_amt ben_enrt_prem.val%TYPE;
839: g_elig_total_premium_uom ben_enrt_prem.uom%TYPE;