APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PRTT_ENRT_RSLT_F

Line 5181: l_enrlt_pl_id ben_prtt_enrt_rslt_f.pl_id%type;

5177: l_rows_found boolean := false;
5178: l_dummy varchar2(1);
5179: l_pl_id ben_elig_prtt_anthr_pl_prte_f.pl_id%type;
5180: l_excld_flag ben_elig_prtt_anthr_pl_prte_f.excld_flag%type;
5181: l_enrlt_pl_id ben_prtt_enrt_rslt_f.pl_id%type;
5182: l_sspndd_flag ben_prtt_enrt_rslt_f.sspndd_flag%type;
5183: l_prtt_is_cvrd_flag ben_prtt_enrt_rslt_f.prtt_is_cvrd_flag%type;
5184: --
5185: cursor c1(p_pl_id in number) is

Line 5182: l_sspndd_flag ben_prtt_enrt_rslt_f.sspndd_flag%type;

5178: l_dummy varchar2(1);
5179: l_pl_id ben_elig_prtt_anthr_pl_prte_f.pl_id%type;
5180: l_excld_flag ben_elig_prtt_anthr_pl_prte_f.excld_flag%type;
5181: l_enrlt_pl_id ben_prtt_enrt_rslt_f.pl_id%type;
5182: l_sspndd_flag ben_prtt_enrt_rslt_f.sspndd_flag%type;
5183: l_prtt_is_cvrd_flag ben_prtt_enrt_rslt_f.prtt_is_cvrd_flag%type;
5184: --
5185: cursor c1(p_pl_id in number) is
5186: select null

Line 5183: l_prtt_is_cvrd_flag ben_prtt_enrt_rslt_f.prtt_is_cvrd_flag%type;

5179: l_pl_id ben_elig_prtt_anthr_pl_prte_f.pl_id%type;
5180: l_excld_flag ben_elig_prtt_anthr_pl_prte_f.excld_flag%type;
5181: l_enrlt_pl_id ben_prtt_enrt_rslt_f.pl_id%type;
5182: l_sspndd_flag ben_prtt_enrt_rslt_f.sspndd_flag%type;
5183: l_prtt_is_cvrd_flag ben_prtt_enrt_rslt_f.prtt_is_cvrd_flag%type;
5184: --
5185: cursor c1(p_pl_id in number) is
5186: select null
5187: from ben_elig_per_f epo,

Line 6264: from ben_prtt_enrt_rslt_f pen

6260: l_dummy varchar2(1);
6261: --
6262: cursor c1(p_date_to_use DATE) is
6263: select null
6264: from ben_prtt_enrt_rslt_f pen
6265: where pen.business_group_id = p_business_group_id
6266: and pen.oipl_id = p_oipl_id
6267: and pen.person_id = p_person_id
6268: and p_date_to_use

Line 6517: ben_prtt_enrt_rslt_f pen

6513: --
6514: cursor c1(p_pl_id in number) is
6515: select null
6516: from ben_elig_cvrd_dpnt_f pdp,
6517: ben_prtt_enrt_rslt_f pen
6518: where pen.business_group_id = p_business_group_id
6519: and pen.pl_id = p_pl_id
6520: and pdp.dpnt_person_id = p_person_id
6521: and l_date_to_use

Line 6635: from ben_prtt_enrt_rslt_f pen

6631: l_dummy varchar2(1);
6632: --
6633: cursor c1(p_plip_id in number,p_date_to_use date) is
6634: select null
6635: from ben_prtt_enrt_rslt_f pen
6636: ,ben_plip_f cpp
6637: where pen.business_group_id = p_business_group_id
6638: and pen.pgm_id = cpp.pgm_id
6639: and pen.pl_id = cpp.pl_id

Line 6755: from ben_prtt_enrt_rslt_f pen

6751: l_dummy varchar2(1);
6752: --
6753: cursor c1(p_plip_id in number,p_date_to_use date ) is
6754: select null
6755: from ben_prtt_enrt_rslt_f pen
6756: ,ben_elig_cvrd_dpnt_f pdp
6757: ,ben_plip_f cpp
6758: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
6759: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')

Line 7077: from ben_prtt_enrt_rslt_f pen

7073: l_dummy varchar2(1);
7074: --
7075: cursor c1(p_ptip_id in number,p_date_to_use date ) is
7076: select pen.pl_id
7077: from ben_prtt_enrt_rslt_f pen
7078: ,ben_elig_cvrd_dpnt_f pdp
7079: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
7080: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
7081: and pen.prtt_enrt_rslt_stat_cd is null

Line 7231: ben_prtt_enrt_rslt_f pen

7227: --
7228: cursor c1(p_pgm_id in number) is
7229: select null
7230: from ben_elig_cvrd_dpnt_f pdp,
7231: ben_prtt_enrt_rslt_f pen
7232: where pen.business_group_id = p_business_group_id
7233: and pen.pgm_id = p_pgm_id
7234: and pdp.dpnt_person_id = p_person_id
7235: and l_date_to_use -- 5550851

Line 7687: from ben_prtt_enrt_rslt_f pen

7683: cursor c_bnft_amt(cp_lf_evt_ocrd_dt in date ,
7684: cp_effective_date in date ,
7685: cp_business_group_id in number) is
7686: select sum(nvl(pen.bnft_amt,0))
7687: from ben_prtt_enrt_rslt_f pen
7688: where pen.business_group_id = cp_business_group_id
7689: and nvl(cp_lf_evt_ocrd_dt,cp_effective_date)
7690: between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
7691: and pen.sspndd_flag = 'N'

Line 7700: from ben_prtt_enrt_rslt_f pen

7696: cp_effective_date in date ,
7697: cp_person_id in number,
7698: cp_business_group_id in number) is
7699: select null
7700: from ben_prtt_enrt_rslt_f pen
7701: where pen.person_id = cp_person_id
7702: and pen.business_group_id = cp_business_group_id
7703: and nvl(cp_lf_evt_ocrd_dt,cp_effective_date)
7704: between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt

Line 7824: from ben_prtt_enrt_rslt_f pen

7820: cursor c_ttl_prtt(cp_lf_evt_ocrd_dt in date ,
7821: cp_effective_date in date ,
7822: cp_business_group_id in number) is
7823: select count(pen.prtt_enrt_rslt_id)
7824: from ben_prtt_enrt_rslt_f pen
7825: where pen.business_group_id = cp_business_group_id
7826: and nvl(cp_lf_evt_ocrd_dt,cp_effective_date)
7827: between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
7828: and pen.sspndd_flag = 'N'

Line 7837: from ben_prtt_enrt_rslt_f pen

7833: cp_effective_date in date ,
7834: cp_person_id in number,
7835: cp_business_group_id in number) is
7836: select null
7837: from ben_prtt_enrt_rslt_f pen
7838: where pen.person_id = cp_person_id
7839: and pen.business_group_id = cp_business_group_id
7840: and nvl(cp_lf_evt_ocrd_dt,cp_effective_date)
7841: between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt

Line 7961: from ben_prtt_enrt_rslt_f pen

7957: cp_lf_evt_ocrd_dt in date ,
7958: cp_effective_date in date ,
7959: cp_business_group_id in number) is
7960: select null
7961: from ben_prtt_enrt_rslt_f pen
7962: where pen.business_group_id = cp_business_group_id
7963: and pen.person_id = cp_person_id
7964: and pen.pl_id = cp_pl_id
7965: and nvl(cp_lf_evt_ocrd_dt,cp_effective_date)

Line 8072: from ben_prtt_enrt_rslt_f pen

8068: cp_lf_evt_ocrd_dt in date ,
8069: cp_effective_date in date ,
8070: cp_business_group_id in number) is
8071: select null
8072: from ben_prtt_enrt_rslt_f pen
8073: , ben_pl_typ_opt_typ_f pto
8074: where pto.pl_typ_opt_typ_id = cp_pl_typ_opt_typ_id
8075: and pto.business_group_id = cp_business_group_id
8076: and nvl(cp_lf_evt_ocrd_dt,cp_effective_date)