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_ENROLMENT_REQUIREMENTS dependencies on BEN_PLIP_F

Line 583: ,p_plip_rec in ben_plip_f%rowtype

579: procedure determine_dflt_enrt_cd
580: (p_oipl_id in number
581: ,p_oipl_rec in ben_oipl_f%rowtype
582: ,p_plip_id in number
583: ,p_plip_rec in ben_plip_f%rowtype
584: ,p_pl_id in number
585: ,p_pl_rec in ben_pl_f%rowtype
586: ,p_ptip_id in number
587: ,p_ptip_rec in ben_ptip_f%rowtype

Line 670: FROM ben_plip_f plp

666: --
667: CURSOR c_plip_dflt_cd IS
668: SELECT plp.dflt_enrt_cd,
669: plp.dflt_enrt_det_rl
670: FROM ben_plip_f plp
671: WHERE p_plip_id = plp.plip_id
672: AND p_effective_date BETWEEN plp.effective_start_date
673: AND plp.effective_end_date;
674: --

Line 710: -- 8 if pgm ben_plip_f

706: --
707: -- 6 if oipl ben_oipl_f (from cache)
708:
709: -- 7 if no pgm ben_pl_f
710: -- 8 if pgm ben_plip_f
711: -- 9 if pgm ben_ptip_f
712: --
713: --End Bug 6061856
714: IF p_oipl_id IS NOT NULL THEN

Line 1685: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip

1681: CURSOR c_ptip_enrolment_info IS
1682: SELECT pen.pl_id,
1683: pen.oipl_id,
1684: plip.plip_id
1685: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip
1686: WHERE pen.person_id = p_person_id
1687: AND pen.business_group_id = p_business_group_id
1688: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1689: --AND pen.sspndd_flag = 'N'

Line 1706: FROM ben_plip_f bpf

1702: AND plip.effective_end_date;
1703: --
1704: CURSOR c_plip_info IS
1705: SELECT bpf.plip_id
1706: FROM ben_plip_f bpf
1707: WHERE bpf.pl_id = p_pl_id
1708: AND bpf.pgm_id = p_pgm_id
1709: AND bpf.business_group_id = p_business_group_id
1710: AND l_lf_evt_ocrd_dt BETWEEN bpf.effective_start_date

Line 2758: l_plip_record ben_plip_f%ROWTYPE;

2754: l_epe_exists number ;
2755: --
2756: -- bug: 5644451
2757: l_oipl_record ben_oipl_f%ROWTYPE;
2758: l_plip_record ben_plip_f%ROWTYPE;
2759: l_ptip_record ben_ptip_f%ROWTYPE;
2760: l_dflt_level varchar2(30);
2761: --
2762: -- define all cursors

Line 3320: FROM ben_plip_f bpf

3316: bpf.alws_unrstrctd_enrt_flag,
3317: bpf.effective_start_date,
3318: bpf.effective_end_date,
3319: bpf.ordr_num
3320: FROM ben_plip_f bpf
3321: WHERE bpf.pl_id = l_pl_id
3322: AND bpf.pgm_id = p_pgm_id
3323: AND bpf.business_group_id = p_business_group_id
3324: AND l_lf_evt_ocrd_dt BETWEEN bpf.effective_start_date

Line 3365: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_plip_f plip

3361: plip.bnft_or_option_rstrctn_cd,
3362: lbr.cvg_incr_r_decr_only_cd,
3363: lbr.mx_cvg_mlt_incr_num,
3364: lbr.mx_cvg_mlt_incr_wcf_num
3365: FROM ben_oipl_f oipl, ben_ler_bnft_rstrn_f lbr, ben_plip_f plip
3366: WHERE plip.plip_id = l_plip_id
3367: AND plip.business_group_id = p_business_group_id
3368: AND plip.bnft_or_option_rstrctn_cd = 'OPT'
3369: AND l_lf_evt_ocrd_dt BETWEEN plip.effective_start_date

Line 3418: FROM ben_oipl_f oipl, ben_plip_f plip

3414: plip.bnft_or_option_rstrctn_cd,
3415: plip.cvg_incr_r_decr_only_cd,
3416: plip.mx_cvg_mlt_incr_num,
3417: plip.mx_cvg_mlt_incr_wcf_num
3418: FROM ben_oipl_f oipl, ben_plip_f plip
3419: WHERE plip.plip_id = l_plip_id
3420: AND plip.bnft_or_option_rstrctn_cd = 'OPT'
3421: AND plip.business_group_id = p_business_group_id
3422: AND l_lf_evt_ocrd_dt BETWEEN plip.effective_start_date

Line 3544: from ben_plip_f plip

3540: ;
3541: --
3542: cursor c_plip_requery(p_id number,p_ed date) is
3543: select 'Y'
3544: from ben_plip_f plip
3545: where plip_id=p_id and
3546: business_group_id=p_business_group_id and
3547: p_ed between effective_start_date and effective_end_date
3548: ;

Line 8793: FROM ben_plip_f plp

8789: --
8790: CURSOR c_plip_dflt_cd IS
8791: SELECT plp.dflt_enrt_cd,
8792: plp.dflt_enrt_det_rl
8793: FROM ben_plip_f plp
8794: WHERE p_plip_id = plp.plip_id
8795: AND p_effective_date BETWEEN plp.effective_start_date
8796: AND plp.effective_end_date;
8797: --

Line 8831: -- 8 if pgm ben_plip_f

8827: -- 5 if pgm ben_ler_chg_ptip_enrt_f
8828: -- 6 if pgm ben_ler_chg_pgm_enrt_f
8829: --
8830: -- 7 if no pgm ben_pl_f
8831: -- 8 if pgm ben_plip_f
8832: -- 9 if pgm ben_ptip_f
8833: --
8834: IF p_oipl_id IS NOT NULL THEN
8835: --

Line 8972: ,p_plip_rec in ben_plip_f%rowtype

8968: procedure determine_dflt_enrt_cd
8969: (p_oipl_id in number
8970: ,p_oipl_rec in ben_oipl_f%rowtype
8971: ,p_plip_id in number
8972: ,p_plip_rec in ben_plip_f%rowtype
8973: ,p_pl_id in number
8974: ,p_pl_rec in ben_pl_f%rowtype
8975: ,p_ptip_id in number
8976: ,p_ptip_rec in ben_ptip_f%rowtype

Line 9059: FROM ben_plip_f plp

9055: --
9056: CURSOR c_plip_dflt_cd IS
9057: SELECT plp.dflt_enrt_cd,
9058: plp.dflt_enrt_det_rl
9059: FROM ben_plip_f plp
9060: WHERE p_plip_id = plp.plip_id
9061: AND p_effective_date BETWEEN plp.effective_start_date
9062: AND plp.effective_end_date;
9063: --

Line 9093: -- 8 if pgm ben_plip_f

9089: -- 5 if pgm ben_ler_chg_ptip_enrt_f
9090: -- 6 if pgm ben_ler_chg_pgm_enrt_f
9091: --
9092: -- 7 if no pgm ben_pl_f
9093: -- 8 if pgm ben_plip_f
9094: -- 9 if pgm ben_ptip_f
9095: --
9096: IF p_oipl_id IS NOT NULL THEN
9097: --

Line 9698: l_plip_rec ben_plip_f%rowtype;

9694: l_empty_oipl ben_oipl_f%rowtype;
9695: l_plan_rec ben_pl_f%rowtype;
9696: l_pgm_rec ben_pgm_f%rowtype;
9697: l_empty_pgm ben_pgm_f%rowtype;
9698: l_plip_rec ben_plip_f%rowtype;
9699: l_empty_plip ben_plip_f%rowtype;
9700: l_ptip_rec ben_ptip_f%rowtype;
9701: l_empty_ptip ben_ptip_f%rowtype;
9702: l_use_dflt_enrt_cd varchar2(30);

Line 9699: l_empty_plip ben_plip_f%rowtype;

9695: l_plan_rec ben_pl_f%rowtype;
9696: l_pgm_rec ben_pgm_f%rowtype;
9697: l_empty_pgm ben_pgm_f%rowtype;
9698: l_plip_rec ben_plip_f%rowtype;
9699: l_empty_plip ben_plip_f%rowtype;
9700: l_ptip_rec ben_ptip_f%rowtype;
9701: l_empty_ptip ben_ptip_f%rowtype;
9702: l_use_dflt_enrt_cd varchar2(30);
9703: l_use_dflt_enrt_rl varchar2(30);

Line 9760: FROM ben_plip_f bpf

9756: -- Gets all information on the plip which is needed
9757: --
9758: CURSOR c_plip_info(p_pl_id number,p_pgm_id number) IS
9759: SELECT bpf.dflt_flag
9760: FROM ben_plip_f bpf
9761: WHERE bpf.pl_id = p_pl_id
9762: AND bpf.pgm_id = p_pgm_id
9763: AND bpf.business_group_id = p_business_group_id
9764: AND l_lf_evt_ocrd_dt BETWEEN bpf.effective_start_date