APPS.BEN_PPR_BUS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 175: from ben_prtt_enrt_rslt_f bper,

171: --
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;

Line 373: FROM ben_prtt_enrt_rslt_f bper,

369: p_prtt_enrt_rslt_id in number,
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')

Line 384: ben_prtt_enrt_rslt_f bper,

380:
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

Line 395: FROM ben_prtt_enrt_rslt_f bper,

391: AND p_effective_date BETWEEN bper.effective_start_date and bper.effective_end_date;
392:
393: CURSOR c3 IS
394: SELECT oipl.oipl_id
395: FROM ben_prtt_enrt_rslt_f bper,
396: ben_oipl_f oipl
397: WHERE bper.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
398: AND oipl.oipl_id = bper.oipl_id
399: AND oipl.pcp_dsgn_cd in ('R','O')

Line 406: ben_prtt_enrt_rslt_f bper,

402:
403: CURSOR c4 IS
404: SELECT bper.prtt_enrt_rslt_id
405: FROM ben_elig_cvrd_dpnt_f becd,
406: ben_prtt_enrt_rslt_f bper,
407: ben_oipl_f oipl
408: WHERE becd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
409: AND becd.prtt_enrt_rslt_id = bper.prtt_enrt_rslt_id
410: AND bper.oipl_id = oipl.oipl_id

Line 561: ben_prtt_enrt_rslt_f pen

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
565: and pct.pcp_typ_cd = p_prmry_care_prvdr_typ_cd

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;

Line 818: (p_base_table_name => 'ben_prtt_enrt_rslt_f',

814: Raise l_integrity_error;
815: End If;
816: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
817: NOT (dt_api.check_min_max_dates
818: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
819: p_base_key_column => 'prtt_enrt_rslt_id',
820: p_base_key_value => p_prtt_enrt_rslt_id,
821: p_from_date => p_validation_start_date,
822: p_to_date => p_validation_end_date))) Then

Line 823: l_table_name := 'ben_prtt_enrt_rslt_f';

819: p_base_key_column => 'prtt_enrt_rslt_id',
820: p_base_key_value => p_prtt_enrt_rslt_id,
821: p_from_date => p_validation_start_date,
822: p_to_date => p_validation_end_date))) Then
823: l_table_name := 'ben_prtt_enrt_rslt_f';
824: Raise l_integrity_error;
825: End If;
826: --
827: End If;