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 1104: from ben_pl_f pln,

1100: --
1101: cursor c_pl_name is
1102: select pln.name,
1103: pen.person_id
1104: from ben_pl_f pln,
1105: ben_prtt_enrt_rslt_f pen
1106: where pln.pl_id = pen.pl_id
1107: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id /* Bug 4039404 */
1108: and pen.prtt_enrt_rslt_stat_cd is null

Line 2326: from ben_pl_f pl

2322: -- Cursor to retrieve dpnt required flags at the plan level
2323: --
2324: cursor c_dpnt_pl (p_pl_id number) is
2325: select pl.susp_if_ctfn_not_dpnt_flag
2326: from ben_pl_f pl
2327: where pl.pl_id = p_pl_id
2328: and pl.business_group_id = p_business_group_id
2329: and p_effective_date between
2330: pl.effective_start_date and pl.effective_end_date;

Line 3262: from ben_pl_f pl

3258: pl.susp_if_dpnt_adr_nt_prv_cd,
3259: pl.susp_if_ctfn_not_dpnt_flag,
3260: pl.dpnt_ctfn_determine_cd,
3261: pl.dpnt_no_ctfn_rqd_flag
3262: from ben_pl_f pl
3263: where pl.pl_id = p_pl_id
3264: and pl.business_group_id = p_business_group_id
3265: and p_effective_date between
3266: pl.effective_start_date and pl.effective_end_date;

Line 5804: from ben_pl_f pln

5800: cursor c_pl_rstrn (p_effective_date date,
5801: p_pl_id number) is
5802: select pln.cvg_incr_r_decr_only_cd,
5803: pln.bnft_or_option_rstrctn_cd
5804: from ben_pl_f pln
5805: where pln.pl_id = p_pl_id
5806: and p_effective_date
5807: between pln.effective_start_date
5808: and pln.effective_end_date;

Line 6199: from ben_pl_f pln

6195: cursor c_pl_rstrn (p_effective_date date,
6196: p_pl_id number) is
6197: select pln.cvg_incr_r_decr_only_cd,
6198: pln.bnft_or_option_rstrctn_cd
6199: from ben_pl_f pln
6200: where pln.pl_id = p_pl_id
6201: and p_effective_date
6202: between pln.effective_start_date
6203: and pln.effective_end_date;

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

7399: ,p_effective_date date)
7400: return boolean is
7401: --
7402: -- Bug 1169240 - checking the popl_actn_typ table to see if action item defined
7403: -- This check is being done because the flags in ben_pl_f table are not getting
7404: -- updated when enrollment action items are attached to a plan . This was noticed
7405: -- for beneficiary related action types.
7406: --
7407: cursor c_bnf_actn_item is

Line 7686: FROM ben_pl_f pl

7682: --
7683: CURSOR c_plan_name(v_plan_id in number)
7684: IS
7685: SELECT pl.NAME
7686: FROM ben_pl_f pl
7687: WHERE pl.pl_id = v_plan_id
7688: AND p_effective_date BETWEEN pl.effective_start_date
7689: AND pl.effective_end_date;
7690:

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

8395: ,p_bnf_actn_item_open out nocopy boolean
8396: ,p_hack out nocopy varchar2) is
8397: --
8398: -- this procedure determines if beneficiaries are required to complete
8399: -- enrollment. For an enrollment result check ben_pl_f.bnf_dsgn_cd
8400: -- if not NULL then a beneficiary is requested so write BNF action item.
8401: -- in additon if the bnf designation is 'R' required, suspend enrollment.
8402: -- or if designation 'O' optional, do not suspend.
8403: --

Line 8744: ben_pl_f pl,

8740: plb.pl_bnf_id,
8741: pl.pl_id
8742: from per_all_people_f per,
8743: per_contact_relationships pcr,
8744: ben_pl_f pl,
8745: ben_pl_bnf_f plb,
8746: ben_prtt_enrt_rslt_f pen,
8747: ben_per_in_ler pil
8748: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 8783: ben_pl_f pl,

8779: plb.pl_bnf_id,
8780: pl.pl_id
8781: from per_all_people_f per,
8782: hr_all_organization_units o,
8783: ben_pl_f pl,
8784: ben_pl_bnf_f plb,
8785: ben_prtt_enrt_rslt_f pen,
8786: ben_per_in_ler pil
8787: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

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

9299:
9300:
9301: l_pcp_actn_warning boolean := FALSE;
9302: l_pcp_dpnt_actn_warning boolean := FALSE;
9303: l_pln_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683
9304: l_person_id per_all_people_f.person_id%type;
9305: l_rslt_object_version_number number(15);
9306:
9307: --

Line 9311: l_pl_id ben_pl_f.pl_id%type;

9307: --
9308: -- Bug : 1857685
9309: --
9310: l_waive_flag varchar2(2) := 'N';
9311: l_pl_id ben_pl_f.pl_id%type;
9312: l_oipl_id ben_oipl_f.oipl_id%type;
9313: l_comp_lvl_cd ben_prtt_enrt_rslt_f.comp_lvl_cd%type;
9314:
9315: --

Line 9329: from ben_pl_f pln

9325: -- Waive plans and options
9326: --
9327: cursor c_waive_pl_flag is
9328: select pln.invk_dcln_prtn_pl_flag
9329: from ben_pl_f pln
9330: where pln.pl_id = l_pl_id
9331: and p_effective_date between
9332: pln.effective_start_date and pln.effective_end_date;
9333: --

Line 9351: ,ben_pl_f pln

9347: cursor c_info_for_msg is
9348: select pen.person_id,
9349: pln.name
9350: from ben_prtt_enrt_rslt_f pen
9351: ,ben_pl_f pln
9352: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
9353: and pen.pl_id= pln.pl_id
9354: and pen.business_group_id = p_business_group_id
9355: and pln.business_group_id = p_business_group_id