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 643: FROM ben_ler_chg_ptip_enrt_f lep

639: --
640: CURSOR c_ler_ptip_dflt_cd IS
641: SELECT lep.dflt_enrt_cd,
642: lep.dflt_enrt_rl
643: FROM ben_ler_chg_ptip_enrt_f lep
644: WHERE p_ptip_id = lep.ptip_id
645: AND p_ler_id = lep.ler_id
646: AND p_effective_date BETWEEN lep.effective_start_date
647: AND lep.effective_end_date;

Line 704: -- 4 if pgm ben_ler_chg_ptip_enrt_f

700: --
701: -- 1 if oipl ben_ler_chg_oipl_enrt_f
702: -- 2 if no pgm ben_ler_chg_pl_nip_enrt_f
703: -- 3 if pgm ben_ler_chg_plip_enrt_f
704: -- 4 if pgm ben_ler_chg_ptip_enrt_f
705: -- 5 if pgm ben_ler_chg_pgm_enrt_f
706: --
707: -- 6 if oipl ben_oipl_f (from cache)
708:

Line 1008: p_ptip_id IN ben_ler_chg_ptip_enrt_f.ptip_id%TYPE,

1004: PROCEDURE determine_ben_settings(
1005: p_pl_id IN ben_ler_chg_pl_nip_enrt_f.pl_id%TYPE,
1006: p_ler_id IN ben_ler_chg_pl_nip_enrt_f.ler_id%TYPE,
1007: p_lf_evt_ocrd_dt IN DATE,
1008: p_ptip_id IN ben_ler_chg_ptip_enrt_f.ptip_id%TYPE,
1009: p_pgm_id IN ben_ler_chg_pgm_enrt_f.pgm_id%TYPE,
1010: p_plip_id IN ben_ler_chg_plip_enrt_f.plip_id%TYPE,
1011: p_oipl_id IN ben_ler_chg_oipl_enrt_f.oipl_id%TYPE,
1012: p_just_prclds_chg_flag IN BOOLEAN DEFAULT FALSE,

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

1016: p_crnt_enrt_prclds_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE,
1017: p_dflt_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE,
1018: p_enrt_mthd_cd OUT NOCOPY ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE,
1019: p_stl_elig_cant_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE,
1020: p_tco_chg_enrt_cd OUT NOCOPY ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE,
1021: p_ler_chg_oipl_found_flag OUT NOCOPY VARCHAR2,
1022: p_ler_chg_found_flag OUT NOCOPY VARCHAR2,
1023: p_enrt_cd_level OUT NOCOPY VARCHAR2 ) IS
1024: -- ========================

Line 1067: FROM ben_ler_chg_ptip_enrt_f ptip

1063: ptip.enrt_rl,
1064: ptip.ler_chg_ptip_enrt_id,
1065: ptip.stl_elig_cant_chg_flag,
1066: ptip.tco_chg_enrt_cd
1067: FROM ben_ler_chg_ptip_enrt_f ptip
1068: WHERE ptip.ptip_id = p_ptip_id
1069: AND ptip.ler_id = p_ler_id
1070: AND p_lf_evt_ocrd_dt BETWEEN ptip.effective_start_date
1071: AND ptip.effective_end_date;

Line 1140: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

1136: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;
1137: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
1138: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1139: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
1140: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1141: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1142: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1143: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1144: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;

Line 1141: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;

1137: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
1138: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1139: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
1140: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1141: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1142: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1143: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1144: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1145: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;

Line 1142: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;

1138: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1139: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
1140: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1141: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1142: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1143: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1144: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1145: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1146: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;

Line 1143: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;

1139: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
1140: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1141: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1142: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1143: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1144: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1145: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1146: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1147: l_temp number; -- 5029028

Line 1144: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;

1140: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1141: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1142: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1143: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1144: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1145: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1146: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1147: l_temp number; -- 5029028
1148: BEGIN

Line 1145: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;

1141: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
1142: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1143: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1144: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1145: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1146: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1147: l_temp number; -- 5029028
1148: BEGIN
1149: -- ============================================

Line 1146: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;

1142: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
1143: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;
1144: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
1145: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1146: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1147: l_temp number; -- 5029028
1148: BEGIN
1149: -- ============================================
1150: -- open,fetch and close each cursor if required

Line 1464: l_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;

1460: l_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
1461: l_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
1462: l_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1463: l_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1464: l_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1465: l_ler_chg_oipl_found_flag VARCHAR2(30);
1466: l_ler_chg_found_flag VARCHAR2(30);
1467: --
1468: -- Gets the enrollments in the ptip and option

Line 1729: ben_ler_chg_ptip_enrt_f ptip,

1725: pgm.crnt_enrt_prclds_chg_flag)))) crnt_enrt_prclds_chg_flag
1726: from dual,
1727: ben_ler_chg_pl_nip_enrt_f pl_nip,
1728: ben_ler_chg_pgm_enrt_f pgm,
1729: ben_ler_chg_ptip_enrt_f ptip,
1730: ben_ler_chg_plip_enrt_f plip,
1731: ben_ler_chg_oipl_enrt_f oipl
1732: where
1733: pl_nip.pl_id(+)=l_enrolled_ptip.pl_id and

Line 8767: FROM ben_ler_chg_ptip_enrt_f lep

8763: --
8764: CURSOR c_ler_ptip_dflt_cd IS
8765: SELECT lep.dflt_enrt_cd,
8766: lep.dflt_enrt_rl
8767: FROM ben_ler_chg_ptip_enrt_f lep
8768: WHERE p_ptip_id = lep.ptip_id
8769: AND p_ler_id = lep.ler_id
8770: AND p_effective_date BETWEEN lep.effective_start_date
8771: AND lep.effective_end_date;

Line 8827: -- 5 if pgm ben_ler_chg_ptip_enrt_f

8823: --
8824: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f
8825: -- 4 if pgm ben_ler_chg_plip_enrt_f
8826: -- 4.5 if pgm ben_ler_chg_pl_nip_enrt_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

Line 9032: FROM ben_ler_chg_ptip_enrt_f lep

9028: --
9029: CURSOR c_ler_ptip_dflt_cd IS
9030: SELECT lep.dflt_enrt_cd,
9031: lep.dflt_enrt_rl
9032: FROM ben_ler_chg_ptip_enrt_f lep
9033: WHERE p_ptip_id = lep.ptip_id
9034: AND p_ler_id = lep.ler_id
9035: AND p_effective_date BETWEEN lep.effective_start_date
9036: AND lep.effective_end_date;

Line 9089: -- 5 if pgm ben_ler_chg_ptip_enrt_f

9085: -- 2 if oipl ben_oipl_f (from cache)
9086: --
9087: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f
9088: -- 4 if pgm ben_ler_chg_plip_enrt_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