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_PGM_ENRT_F

Line 652: FROM ben_ler_chg_pgm_enrt_f lep

648: --
649: CURSOR c_ler_pgm_dflt_cd IS
650: SELECT lep.dflt_enrt_cd,
651: lep.dflt_enrt_rl
652: FROM ben_ler_chg_pgm_enrt_f lep
653: WHERE p_pgm_id = lep.pgm_id
654: AND p_ler_id = lep.ler_id
655: AND p_effective_date BETWEEN lep.effective_start_date
656: AND lep.effective_end_date;

Line 705: -- 5 if pgm ben_ler_chg_pgm_enrt_f

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:
709: -- 7 if no pgm ben_pl_f

Line 1009: p_pgm_id IN ben_ler_chg_pgm_enrt_f.pgm_id%TYPE,

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,
1013: p_enrt_cd OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE,

Line 1018: p_enrt_mthd_cd OUT NOCOPY ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE,

1014: p_enrt_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE,
1015: p_auto_enrt_mthd_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%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,

Line 1053: FROM ben_ler_chg_pgm_enrt_f pgm

1049: pgm.enrt_mthd_cd,
1050: pgm.enrt_rl,
1051: pgm.ler_chg_pgm_enrt_id,
1052: pgm.stl_elig_cant_chg_flag
1053: FROM ben_ler_chg_pgm_enrt_f pgm
1054: WHERE pgm.pgm_id = p_pgm_id
1055: AND pgm.ler_id = p_ler_id
1056: AND p_lf_evt_ocrd_dt BETWEEN pgm.effective_start_date
1057: AND pgm.effective_end_date;

Line 1115: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;

1111: oipl_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;
1112: oipl_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;
1113: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;
1114: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1115: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1116: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1117: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1118: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1119: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;

Line 1116: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

1112: oipl_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;
1113: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;
1114: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1115: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1116: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1117: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1118: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1119: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1120: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;

Line 1117: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;

1113: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;
1114: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1115: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1116: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1117: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1118: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1119: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1120: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1121: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;

Line 1118: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;

1114: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1115: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1116: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1117: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1118: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1119: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1120: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1121: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
1122: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;

Line 1119: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;

1115: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1116: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1117: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1118: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1119: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1120: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1121: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
1122: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
1123: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

Line 1120: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;

1116: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1117: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1118: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1119: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1120: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1121: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
1122: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
1123: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1124: pnip_dflt_flag ben_ler_chg_pl_nip_enrt_f.dflt_flag%TYPE;

Line 1121: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;

1117: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1118: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1119: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1120: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1121: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
1122: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
1123: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1124: pnip_dflt_flag ben_ler_chg_pl_nip_enrt_f.dflt_flag%TYPE;
1125: pnip_enrt_cd ben_ler_chg_pl_nip_enrt_f.enrt_cd%TYPE;

Line 1462: l_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;

1458: l_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;
1459: l_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%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);

Line 1728: ben_ler_chg_pgm_enrt_f pgm,

1724: nvl(ptip.crnt_enrt_prclds_chg_flag,
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

Line 8776: FROM ben_ler_chg_pgm_enrt_f lep

8772: --
8773: CURSOR c_ler_pgm_dflt_cd IS
8774: SELECT lep.dflt_enrt_cd,
8775: lep.dflt_enrt_rl
8776: FROM ben_ler_chg_pgm_enrt_f lep
8777: WHERE p_pgm_id = lep.pgm_id
8778: AND p_ler_id = lep.ler_id
8779: AND p_effective_date BETWEEN lep.effective_start_date
8780: AND lep.effective_end_date;

Line 8828: -- 6 if pgm ben_ler_chg_pgm_enrt_f

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
8832: -- 9 if pgm ben_ptip_f

Line 9041: FROM ben_ler_chg_pgm_enrt_f lep

9037: --
9038: CURSOR c_ler_pgm_dflt_cd IS
9039: SELECT lep.dflt_enrt_cd,
9040: lep.dflt_enrt_rl
9041: FROM ben_ler_chg_pgm_enrt_f lep
9042: WHERE p_pgm_id = lep.pgm_id
9043: AND p_ler_id = lep.ler_id
9044: AND p_effective_date BETWEEN lep.effective_start_date
9045: AND lep.effective_end_date;

Line 9090: -- 6 if pgm ben_ler_chg_pgm_enrt_f

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
9094: -- 9 if pgm ben_ptip_f