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_LER_CHG_PTIP_ENRT_F

Line 616: FROM ben_ler_chg_ptip_enrt_f lep

612: --
613: CURSOR c_ler_ptip_dflt_cd IS
614: SELECT lep.dflt_enrt_cd,
615: lep.dflt_enrt_rl
616: FROM ben_ler_chg_ptip_enrt_f lep
617: WHERE p_ptip_id = lep.ptip_id
618: AND p_ler_id = lep.ler_id
619: AND p_effective_date BETWEEN lep.effective_start_date
620: AND lep.effective_end_date;

Line 677: -- 4 if pgm ben_ler_chg_ptip_enrt_f

673: --
674: -- 1 if oipl ben_ler_chg_oipl_enrt_f
675: -- 2 if no pgm ben_ler_chg_pl_nip_enrt_f
676: -- 3 if pgm ben_ler_chg_plip_enrt_f
677: -- 4 if pgm ben_ler_chg_ptip_enrt_f
678: -- 5 if pgm ben_ler_chg_pgm_enrt_f
679: --
680: -- 6 if oipl ben_oipl_f (from cache)
681:

Line 981: p_ptip_id IN ben_ler_chg_ptip_enrt_f.ptip_id%TYPE,

977: PROCEDURE determine_ben_settings(
978: p_pl_id IN ben_ler_chg_pl_nip_enrt_f.pl_id%TYPE,
979: p_ler_id IN ben_ler_chg_pl_nip_enrt_f.ler_id%TYPE,
980: p_lf_evt_ocrd_dt IN DATE,
981: p_ptip_id IN ben_ler_chg_ptip_enrt_f.ptip_id%TYPE,
982: p_pgm_id IN ben_ler_chg_pgm_enrt_f.pgm_id%TYPE,
983: p_plip_id IN ben_ler_chg_plip_enrt_f.plip_id%TYPE,
984: p_oipl_id IN ben_ler_chg_oipl_enrt_f.oipl_id%TYPE,
985: p_just_prclds_chg_flag IN BOOLEAN DEFAULT FALSE,

Line 993: p_tco_chg_enrt_cd OUT NOCOPY ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE,

989: p_crnt_enrt_prclds_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE,
990: p_dflt_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE,
991: p_enrt_mthd_cd OUT NOCOPY ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE,
992: p_stl_elig_cant_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE,
993: p_tco_chg_enrt_cd OUT NOCOPY ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE,
994: p_ler_chg_oipl_found_flag OUT NOCOPY VARCHAR2,
995: p_ler_chg_found_flag OUT NOCOPY VARCHAR2,
996: p_enrt_cd_level OUT NOCOPY VARCHAR2 ) IS
997: -- ========================

Line 1040: FROM ben_ler_chg_ptip_enrt_f ptip

1036: ptip.enrt_rl,
1037: ptip.ler_chg_ptip_enrt_id,
1038: ptip.stl_elig_cant_chg_flag,
1039: ptip.tco_chg_enrt_cd
1040: FROM ben_ler_chg_ptip_enrt_f ptip
1041: WHERE ptip.ptip_id = p_ptip_id
1042: AND ptip.ler_id = p_ler_id
1043: AND p_lf_evt_ocrd_dt BETWEEN ptip.effective_start_date
1044: AND ptip.effective_end_date;

Line 1113: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

1109: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;
1110: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
1111: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1112: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
1113: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1114: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1115: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1116: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1117: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;

Line 1114: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;

1110: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
1111: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1112: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
1113: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1114: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1115: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1116: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1117: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1118: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;

Line 1115: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;

1111: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1112: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
1113: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1114: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1115: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1116: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1117: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1118: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1119: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;

Line 1116: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;

1112: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
1113: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1114: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1115: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1116: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1117: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1118: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1119: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1120: l_temp number; -- 5029028

Line 1117: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;

1113: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1114: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1115: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1116: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1117: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1118: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1119: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1120: l_temp number; -- 5029028
1121: BEGIN

Line 1118: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;

1114: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1115: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1116: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1117: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1118: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1119: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1120: l_temp number; -- 5029028
1121: BEGIN
1122: -- ============================================

Line 1119: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;

1115: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1116: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1117: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1118: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1119: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1120: l_temp number; -- 5029028
1121: BEGIN
1122: -- ============================================
1123: -- open,fetch and close each cursor if required

Line 1437: l_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;

1433: l_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
1434: l_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
1435: l_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1436: l_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1437: l_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1438: l_ler_chg_oipl_found_flag VARCHAR2(30);
1439: l_ler_chg_found_flag VARCHAR2(30);
1440: --
1441: -- Gets the enrollments in the ptip and option

Line 1702: ben_ler_chg_ptip_enrt_f ptip,

1698: pgm.crnt_enrt_prclds_chg_flag)))) crnt_enrt_prclds_chg_flag
1699: from dual,
1700: ben_ler_chg_pl_nip_enrt_f pl_nip,
1701: ben_ler_chg_pgm_enrt_f pgm,
1702: ben_ler_chg_ptip_enrt_f ptip,
1703: ben_ler_chg_plip_enrt_f plip,
1704: ben_ler_chg_oipl_enrt_f oipl
1705: where
1706: pl_nip.pl_id(+)=l_enrolled_ptip.pl_id and

Line 8628: FROM ben_ler_chg_ptip_enrt_f lep

8624: --
8625: CURSOR c_ler_ptip_dflt_cd IS
8626: SELECT lep.dflt_enrt_cd,
8627: lep.dflt_enrt_rl
8628: FROM ben_ler_chg_ptip_enrt_f lep
8629: WHERE p_ptip_id = lep.ptip_id
8630: AND p_ler_id = lep.ler_id
8631: AND p_effective_date BETWEEN lep.effective_start_date
8632: AND lep.effective_end_date;

Line 8688: -- 5 if pgm ben_ler_chg_ptip_enrt_f

8684: --
8685: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f
8686: -- 4 if pgm ben_ler_chg_plip_enrt_f
8687: -- 4.5 if pgm ben_ler_chg_pl_nip_enrt_f
8688: -- 5 if pgm ben_ler_chg_ptip_enrt_f
8689: -- 6 if pgm ben_ler_chg_pgm_enrt_f
8690: --
8691: -- 7 if no pgm ben_pl_f
8692: -- 8 if pgm ben_plip_f

Line 8893: FROM ben_ler_chg_ptip_enrt_f lep

8889: --
8890: CURSOR c_ler_ptip_dflt_cd IS
8891: SELECT lep.dflt_enrt_cd,
8892: lep.dflt_enrt_rl
8893: FROM ben_ler_chg_ptip_enrt_f lep
8894: WHERE p_ptip_id = lep.ptip_id
8895: AND p_ler_id = lep.ler_id
8896: AND p_effective_date BETWEEN lep.effective_start_date
8897: AND lep.effective_end_date;

Line 8950: -- 5 if pgm ben_ler_chg_ptip_enrt_f

8946: -- 2 if oipl ben_oipl_f (from cache)
8947: --
8948: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f
8949: -- 4 if pgm ben_ler_chg_plip_enrt_f
8950: -- 5 if pgm ben_ler_chg_ptip_enrt_f
8951: -- 6 if pgm ben_ler_chg_pgm_enrt_f
8952: --
8953: -- 7 if no pgm ben_pl_f
8954: -- 8 if pgm ben_plip_f