APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 91: from ben_elig_per_elctbl_chc epe

87: )
88: is
89: select epe.pgm_id,
90: epe.pl_id
91: from ben_elig_per_elctbl_chc epe
92: where epe.elig_per_elctbl_chc_id = c_epe_id;
93: --
94: l_epedets c_epedets%rowtype;
95: --

Line 531: from BEN_ELIG_PER_ELCTBL_CHC epe,

527: pil.per_in_ler_id,
528: pil.business_group_id,
529: pil.ler_id,
530: pil.per_in_ler_stat_cd
531: from BEN_ELIG_PER_ELCTBL_CHC epe,
532: ben_per_in_ler pil,
533: per_all_people_f per
534: where pil.per_in_ler_id = epe.per_in_ler_id
535: and epe.ELIG_PER_ELCTBL_CHC_id = c_epe_id

Line 554: BEN_ELIG_PER_ELCTBL_CHC epe,

550: pil.ler_id,
551: pil.per_in_ler_stat_cd,
552: enb.val
553: from ben_enrt_bnft enb,
554: BEN_ELIG_PER_ELCTBL_CHC epe,
555: ben_per_in_ler pil,
556: per_all_people_f per
557: where enb.ELIG_PER_ELCTBL_CHC_id = epe.ELIG_PER_ELCTBL_CHC_id
558: and pil.per_in_ler_id = epe.per_in_ler_id

Line 578: BEN_ELIG_PER_ELCTBL_CHC epe,

574: pil.ler_id,
575: pil.per_in_ler_stat_cd,
576: enb.val
577: from ben_enrt_bnft enb,
578: BEN_ELIG_PER_ELCTBL_CHC epe,
579: ben_per_in_ler pil
580: where enb.ELIG_PER_ELCTBL_CHC_id = epe.ELIG_PER_ELCTBL_CHC_id
581: and pil.per_in_ler_id = epe.per_in_ler_id
582: and enb.enrt_bnft_id = c_enb_id;

Line 2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type

2787: ,mx_val ben_enrt_bnft.mx_val%type
2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type
2789: ,dflt_val ben_enrt_bnft.dflt_val%type
2790: ,val ben_enrt_bnft.val%type
2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type
2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type

Line 2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type

2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type
2789: ,dflt_val ben_enrt_bnft.dflt_val%type
2790: ,val ben_enrt_bnft.val%type
2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type
2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type
2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type

Line 2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type

2789: ,dflt_val ben_enrt_bnft.dflt_val%type
2790: ,val ben_enrt_bnft.val%type
2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type
2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type
2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type

Line 2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type

2790: ,val ben_enrt_bnft.val%type
2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type
2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type
2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type

Line 2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type

2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type
2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type
2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type
2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%type

Line 2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type

2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type
2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type
2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type
2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%type
2800: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type

Line 2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type

2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type
2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type
2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%type
2800: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
2801: ,person_id ben_per_in_ler.person_id%type

Line 2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type

2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type
2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type
2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%type
2800: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
2801: ,person_id ben_per_in_ler.person_id%type
2802: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

Line 2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%type

2795: ,plip_id ben_elig_per_elctbl_chc.plip_id%type
2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type
2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%type
2800: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
2801: ,person_id ben_per_in_ler.person_id%type
2802: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2803: ,ler_id ben_per_in_ler.ler_id%type

Line 3022: ||' BEN_ELIG_PER_ELCTBL_CHC epe, '

3018: --
3019: end if;
3020: --
3021: l_from_str := ' FROM ben_enrt_bnft enb, '
3022: ||' BEN_ELIG_PER_ELCTBL_CHC epe, '
3023: ||' ben_per_in_ler pil, '
3024: ||' per_all_people_f per ';
3025: --
3026: l_where_str := ' where enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id '

Line 4017: from BEN_ELIG_PER_ELCTBL_CHC epe,

4013: (c_epe_id in number
4014: )
4015: is
4016: select enb.val
4017: from BEN_ELIG_PER_ELCTBL_CHC epe,
4018: ben_enrt_bnft enb
4019: where epe.ELIG_PER_ELCTBL_CHC_id = c_epe_id
4020: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id;
4021: --

Line 4677: from BEN_ELIG_PER_ELCTBL_CHC epe,

4673: (c_epe_id in number
4674: )
4675: is
4676: select enb.val
4677: from BEN_ELIG_PER_ELCTBL_CHC epe,
4678: ben_enrt_bnft enb
4679: where epe.ELIG_PER_ELCTBL_CHC_id = c_epe_id
4680: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id;
4681: --

Line 4765: ben_elig_per_elctbl_chc epe

4761: select epr.val,
4762: pil.per_in_ler_stat_cd
4763: from ben_enrt_prem epr,
4764: ben_per_in_ler pil,
4765: ben_elig_per_elctbl_chc epe
4766: where epr.actl_prem_id = c_actl_prem_id
4767: and epr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
4768: and epe.elig_per_elctbl_chc_id = epr.elig_per_elctbl_chc_id
4769: and pil.per_in_ler_id = epe.per_in_ler_id;