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_PTIP_F

Line 587: ,p_ptip_rec in ben_ptip_f%rowtype

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
588: ,p_pgm_id in number
589: ,p_pgm_rec in ben_pgm_f%rowtype
590: ,p_ler_id in number
591: ,p_business_group_id in number

Line 678: FROM ben_ptip_f ptp

674: --
675: CURSOR c_ptip_dflt_cd IS
676: SELECT ptp.dflt_enrt_cd,
677: ptp.dflt_enrt_det_rl
678: FROM ben_ptip_f ptp
679: WHERE p_ptip_id = ptp.ptip_id
680: AND p_effective_date BETWEEN ptp.effective_start_date
681: AND ptp.effective_end_date;
682: --

Line 711: -- 9 if pgm ben_ptip_f

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

Line 2759: l_ptip_record ben_ptip_f%ROWTYPE;

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

Line 3337: FROM ben_ptip_f ptip

3333: ptip.auto_enrt_mthd_rl,
3334: ptip.effective_start_date,
3335: ptip.effective_end_date,
3336: ptip.ordr_num
3337: FROM ben_ptip_f ptip
3338: WHERE ptip.pl_typ_id = l_pl_typ_id
3339: AND ptip.pgm_id = p_pgm_id
3340: AND ptip.business_group_id = p_business_group_id
3341: AND l_lf_evt_ocrd_dt BETWEEN ptip.effective_start_date

Line 3552: from ben_ptip_f ptip

3548: ;
3549: --
3550: cursor c_ptip_requery(p_id number,p_ed date) is
3551: select 'Y'
3552: from ben_ptip_f ptip
3553: where ptip_id=p_id and
3554: business_group_id=p_business_group_id and
3555: p_ed between effective_start_date and effective_end_date
3556: ;

Line 8801: FROM ben_ptip_f ptp

8797: --
8798: CURSOR c_ptip_dflt_cd IS
8799: SELECT ptp.dflt_enrt_cd,
8800: ptp.dflt_enrt_det_rl
8801: FROM ben_ptip_f ptp
8802: WHERE p_ptip_id = ptp.ptip_id
8803: AND p_effective_date BETWEEN ptp.effective_start_date
8804: AND ptp.effective_end_date;
8805: --

Line 8832: -- 9 if pgm ben_ptip_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: --
8836: -- 1

Line 8976: ,p_ptip_rec in ben_ptip_f%rowtype

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
8977: ,p_pgm_id in number
8978: ,p_pgm_rec in ben_pgm_f%rowtype
8979: ,p_ler_id in number
8980: ,p_business_group_id in number

Line 9067: FROM ben_ptip_f ptp

9063: --
9064: CURSOR c_ptip_dflt_cd IS
9065: SELECT ptp.dflt_enrt_cd,
9066: ptp.dflt_enrt_det_rl
9067: FROM ben_ptip_f ptp
9068: WHERE p_ptip_id = ptp.ptip_id
9069: AND p_effective_date BETWEEN ptp.effective_start_date
9070: AND ptp.effective_end_date;
9071: --

Line 9094: -- 9 if pgm ben_ptip_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: --
9098: -- 1

Line 9410: FROM ben_ptip_f bp

9406: SELECT '4',
9407: bp.rqd_perd_enrt_nenrt_tm_uom,
9408: bp.rqd_perd_enrt_nenrt_val,
9409: bp.rqd_perd_enrt_nenrt_rl
9410: FROM ben_ptip_f bp
9411: WHERE bp.ptip_id = p_ptip_id
9412: AND p_effective_date BETWEEN bp.effective_start_date
9413: AND bp.effective_end_date
9414: AND bp.business_group_id = p_business_group_id

Line 9700: l_ptip_rec ben_ptip_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);
9704: l_reinstt_flag varchar2(30);

Line 9701: l_empty_ptip ben_ptip_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);
9704: l_reinstt_flag varchar2(30);
9705: l_dflt_level varchar2(30);