APPS.BEN_PPR_BUS dependencies on BEN_PL_PCP

Line 176: ben_pl_pcp bpp

172: Begin
173: select bpp.pcp_rpstry_flag
174: into l_pcp_rpstry_flag
175: from ben_prtt_enrt_rslt_f bper,
176: ben_pl_pcp bpp
177: where bper.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
178: and bper.pl_id = bpp.pl_id
179: and p_effective_date between bper.effective_start_date and bper.effective_end_date;
180:

Line 374: ben_pl_pcp bpp

370: p_effective_date in date) is
371: CURSOR c1 IS
372: SELECT bper.pl_id
373: FROM ben_prtt_enrt_rslt_f bper,
374: ben_pl_pcp bpp
375: WHERE bper.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
376: AND bper.pl_id = bpp.pl_id
377: AND bpp.pcp_dsgn_cd in ('R','O')
378: AND p_effective_date BETWEEN bper.effective_start_date and bper.effective_end_date;

Line 385: ben_pl_pcp bpp

381: CURSOR c2 IS
382: SELECT bper.prtt_enrt_rslt_id
383: FROM ben_elig_cvrd_dpnt_f becd,
384: ben_prtt_enrt_rslt_f bper,
385: ben_pl_pcp bpp
386: WHERE becd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
387: AND becd.prtt_enrt_rslt_id = bper.prtt_enrt_rslt_id
388: AND bper.pl_id = bpp.pl_id
389: AND bpp.pcp_dpnt_dsgn_cd in ('R','O')

Line 544: l_min_age ben_pl_pcp_typ.min_age%type;

540: p_prmry_care_prvdr_typ_cd in varchar2,
541: p_effective_date in date) is
542:
543: l_proc varchar2(72) := g_package|| ' chk_age_gendr_ppr_record' ;
544: l_min_age ben_pl_pcp_typ.min_age%type;
545: l_max_age ben_pl_pcp_typ.max_age%type;
546: l_min_msg varchar2(30) := 'n/a';
547: l_max_msg varchar2(30) := 'n/a';
548: l_sex varchar2(30);

Line 545: l_max_age ben_pl_pcp_typ.max_age%type;

541: p_effective_date in date) is
542:
543: l_proc varchar2(72) := g_package|| ' chk_age_gendr_ppr_record' ;
544: l_min_age ben_pl_pcp_typ.min_age%type;
545: l_max_age ben_pl_pcp_typ.max_age%type;
546: l_min_msg varchar2(30) := 'n/a';
547: l_max_msg varchar2(30) := 'n/a';
548: l_sex varchar2(30);
549: l_gender varchar2(30);

Line 559: from ben_pl_pcp_typ pct,

555:
556: cursor c_plan_design(p_rslt_id number) is
557: select pen.person_id, nvl(pct.min_age,-1),
558: nvl(pct.max_age,9999), pct.gndr_alwd_cd
559: from ben_pl_pcp_typ pct,
560: ben_pl_pcp pcp,
561: ben_prtt_enrt_rslt_f pen
562: where pen.prtt_enrt_rslt_id = p_rslt_id
563: and pen.pl_id = pcp.pl_id

Line 560: ben_pl_pcp pcp,

556: cursor c_plan_design(p_rslt_id number) is
557: select pen.person_id, nvl(pct.min_age,-1),
558: nvl(pct.max_age,9999), pct.gndr_alwd_cd
559: from ben_pl_pcp_typ pct,
560: ben_pl_pcp pcp,
561: ben_prtt_enrt_rslt_f pen
562: where pen.prtt_enrt_rslt_id = p_rslt_id
563: and pen.pl_id = pcp.pl_id
564: and pcp.pl_pcp_id = pct.pl_pcp_id

Line 686: from ben_prtt_enrt_rslt_f pen, ben_pl_pcp pcp

682: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id;
683:
684: cursor c_pcp (p_prtt_enrt_rslt_id number) is
685: select pcp.pcp_num_chgs
686: from ben_prtt_enrt_rslt_f pen, ben_pl_pcp pcp
687: Where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
688: and pen.pl_id = pcp.pl_id
689: and p_effective_date between
690: pen.effective_start_date and pen.effective_end_date;