DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 515: g_enrt_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;

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

Line 791: g_elig_enrt_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%TYPE;

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

Line 792: g_elig_enrt_end_dt ben_pil_elctbl_chc_popl.enrt_perd_end_dt%TYPE;

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

Line 793: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;

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

Line 794: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;

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

Line 838: g_elig_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;

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