eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_F

Line 1117: from ben_pl_f pln,

1113: --
1114: cursor c_pl_name is
1115: select pln.name,
1116: pen.person_id
1117: from ben_pl_f pln,
1118: ben_prtt_enrt_rslt_f pen
1119: where pln.pl_id = pen.pl_id
1120: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id /* Bug 4039404 */
1121: and pen.prtt_enrt_rslt_stat_cd is null

Line 2339: from ben_pl_f pl

2335: -- Cursor to retrieve dpnt required flags at the plan level
2336: --
2337: cursor c_dpnt_pl (p_pl_id number) is
2338: select pl.susp_if_ctfn_not_dpnt_flag
2339: from ben_pl_f pl
2340: where pl.pl_id = p_pl_id
2341: and pl.business_group_id = p_business_group_id
2342: and p_effective_date between
2343: pl.effective_start_date and pl.effective_end_date;

Line 3275: from ben_pl_f pl

3271: pl.susp_if_dpnt_adr_nt_prv_cd,
3272: pl.susp_if_ctfn_not_dpnt_flag,
3273: pl.dpnt_ctfn_determine_cd,
3274: pl.dpnt_no_ctfn_rqd_flag
3275: from ben_pl_f pl
3276: where pl.pl_id = p_pl_id
3277: and pl.business_group_id = p_business_group_id
3278: and p_effective_date between
3279: pl.effective_start_date and pl.effective_end_date;

Line 5882: from ben_pl_f pln

5878: cursor c_pl_rstrn (p_effective_date date,
5879: p_pl_id number) is
5880: select pln.cvg_incr_r_decr_only_cd,
5881: pln.bnft_or_option_rstrctn_cd
5882: from ben_pl_f pln
5883: where pln.pl_id = p_pl_id
5884: and p_effective_date
5885: between pln.effective_start_date
5886: and pln.effective_end_date;

Line 6277: from ben_pl_f pln

6273: cursor c_pl_rstrn (p_effective_date date,
6274: p_pl_id number) is
6275: select pln.cvg_incr_r_decr_only_cd,
6276: pln.bnft_or_option_rstrctn_cd
6277: from ben_pl_f pln
6278: where pln.pl_id = p_pl_id
6279: and p_effective_date
6280: between pln.effective_start_date
6281: and pln.effective_end_date;

Line 7488: -- This check is being done because the flags in ben_pl_f table are not getting

7484: ,p_effective_date date)
7485: return boolean is
7486: --
7487: -- Bug 1169240 - checking the popl_actn_typ table to see if action item defined
7488: -- This check is being done because the flags in ben_pl_f table are not getting
7489: -- updated when enrollment action items are attached to a plan . This was noticed
7490: -- for beneficiary related action types.
7491: --
7492: cursor c_bnf_actn_item is

Line 7771: FROM ben_pl_f pl

7767: --
7768: CURSOR c_plan_name(v_plan_id in number)
7769: IS
7770: SELECT pl.NAME
7771: FROM ben_pl_f pl
7772: WHERE pl.pl_id = v_plan_id
7773: AND p_effective_date BETWEEN pl.effective_start_date
7774: AND pl.effective_end_date;
7775:

Line 8484: -- enrollment. For an enrollment result check ben_pl_f.bnf_dsgn_cd

8480: ,p_bnf_actn_item_open out nocopy boolean
8481: ,p_hack out nocopy varchar2) is
8482: --
8483: -- this procedure determines if beneficiaries are required to complete
8484: -- enrollment. For an enrollment result check ben_pl_f.bnf_dsgn_cd
8485: -- if not NULL then a beneficiary is requested so write BNF action item.
8486: -- in additon if the bnf designation is 'R' required, suspend enrollment.
8487: -- or if designation 'O' optional, do not suspend.
8488: --

Line 8829: ben_pl_f pl,

8825: plb.pl_bnf_id,
8826: pl.pl_id
8827: from per_all_people_f per,
8828: per_contact_relationships pcr,
8829: ben_pl_f pl,
8830: ben_pl_bnf_f plb,
8831: ben_prtt_enrt_rslt_f pen,
8832: ben_per_in_ler pil
8833: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 8868: ben_pl_f pl,

8864: plb.pl_bnf_id,
8865: pl.pl_id
8866: from per_all_people_f per,
8867: hr_all_organization_units o,
8868: ben_pl_f pl,
8869: ben_pl_bnf_f plb,
8870: ben_prtt_enrt_rslt_f pen,
8871: ben_per_in_ler pil
8872: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 9388: l_pln_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683

9384:
9385:
9386: l_pcp_actn_warning boolean := FALSE;
9387: l_pcp_dpnt_actn_warning boolean := FALSE;
9388: l_pln_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683
9389: l_person_id per_all_people_f.person_id%type;
9390: l_rslt_object_version_number number(15);
9391:
9392: --

Line 9396: l_pl_id ben_pl_f.pl_id%type;

9392: --
9393: -- Bug : 1857685
9394: --
9395: l_waive_flag varchar2(2) := 'N';
9396: l_pl_id ben_pl_f.pl_id%type;
9397: l_oipl_id ben_oipl_f.oipl_id%type;
9398: l_comp_lvl_cd ben_prtt_enrt_rslt_f.comp_lvl_cd%type;
9399:
9400: --

Line 9414: from ben_pl_f pln

9410: -- Waive plans and options
9411: --
9412: cursor c_waive_pl_flag is
9413: select pln.invk_dcln_prtn_pl_flag
9414: from ben_pl_f pln
9415: where pln.pl_id = l_pl_id
9416: and p_effective_date between
9417: pln.effective_start_date and pln.effective_end_date;
9418: --

Line 9436: ,ben_pl_f pln

9432: cursor c_info_for_msg is
9433: select pen.person_id,
9434: pln.name
9435: from ben_prtt_enrt_rslt_f pen
9436: ,ben_pl_f pln
9437: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
9438: and pen.pl_id= pln.pl_id
9439: and pen.business_group_id = p_business_group_id
9440: and pln.business_group_id = p_business_group_id