APPS.BEN_PPR_BUS dependencies on BEN_PL_PCP_TYP

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