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_PL_NIP_ENRT_F

Line 624: FROM ben_ler_chg_pl_nip_enrt_f len

620: CURSOR c_ler_pl_nip_dflt_cd IS
621: SELECT len.dflt_enrt_cd,
622: len.dflt_enrt_rl,
623: len.dflt_flag
624: FROM ben_ler_chg_pl_nip_enrt_f len
625: WHERE p_pl_id = len.pl_id
626: AND p_ler_id = len.ler_id
627: AND p_effective_date BETWEEN len.effective_start_date
628: AND len.effective_end_date;

Line 702: -- 2 if no pgm ben_ler_chg_pl_nip_enrt_f

698: --Start Bug 6061856 -- Modified the Ordering, moved oipl to 6
699: -- Hierarchy
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: --

Line 1005: p_pl_id IN ben_ler_chg_pl_nip_enrt_f.pl_id%TYPE,

1001: --
1002: END;
1003: -- end internal determine_dflt_enrt_cd
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,

Line 1006: p_ler_id IN ben_ler_chg_pl_nip_enrt_f.ler_id%TYPE,

1002: END;
1003: -- end internal determine_dflt_enrt_cd
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,

Line 1099: FROM ben_ler_chg_pl_nip_enrt_f pl_nip

1095: pl_nip.enrt_rl,
1096: pl_nip.ler_chg_pl_nip_enrt_id,
1097: pl_nip.stl_elig_cant_chg_flag,
1098: pl_nip.tco_chg_enrt_cd
1099: FROM ben_ler_chg_pl_nip_enrt_f pl_nip
1100: WHERE pl_nip.pl_id = p_pl_id
1101: AND pl_nip.ler_id = p_ler_id
1102: AND p_lf_evt_ocrd_dt BETWEEN pl_nip.effective_start_date
1103: AND pl_nip.effective_end_date;

Line 1122: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%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;
1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;

Line 1123: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%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;
1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
1127: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;

Line 1124: pnip_dflt_flag ben_ler_chg_pl_nip_enrt_f.dflt_flag%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;
1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
1127: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;
1128: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;

Line 1125: pnip_enrt_cd ben_ler_chg_pl_nip_enrt_f.enrt_cd%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;
1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
1127: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;
1128: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
1129: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;

Line 1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;
1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
1127: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;
1128: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
1129: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1130: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;

Line 1127: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_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;
1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
1127: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;
1128: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
1129: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1130: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
1131: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;

Line 1128: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%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;
1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
1127: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;
1128: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
1129: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1130: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
1131: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
1132: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

Line 1129: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;

1125: pnip_enrt_cd ben_ler_chg_pl_nip_enrt_f.enrt_cd%TYPE;
1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
1127: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;
1128: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
1129: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1130: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
1131: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
1132: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1133: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;

Line 1130: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;

1126: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
1127: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;
1128: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
1129: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1130: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
1131: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
1132: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1133: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
1134: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;

Line 1727: ben_ler_chg_pl_nip_enrt_f pl_nip,

1723: nvl(plip.crnt_enrt_prclds_chg_flag,
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

Line 8749: FROM ben_ler_chg_pl_nip_enrt_f len

8745: --
8746: CURSOR c_ler_pl_nip_dflt_cd IS
8747: SELECT len.dflt_enrt_cd,
8748: len.dflt_enrt_rl
8749: FROM ben_ler_chg_pl_nip_enrt_f len
8750: WHERE p_pl_id = len.pl_id
8751: AND p_ler_id = len.ler_id
8752: AND p_effective_date BETWEEN len.effective_start_date
8753: AND len.effective_end_date;

Line 8824: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f

8820: --
8821: -- 1 if oipl ben_ler_chg_oipl_enrt_f
8822: -- 2 if oipl ben_oipl_f (from cache)
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

Line 8826: -- 4.5 if pgm ben_ler_chg_pl_nip_enrt_f

8822: -- 2 if oipl ben_oipl_f (from cache)
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

Line 9013: FROM ben_ler_chg_pl_nip_enrt_f len

9009: CURSOR c_ler_pl_nip_dflt_cd IS
9010: SELECT len.dflt_enrt_cd,
9011: len.dflt_enrt_rl,
9012: len.dflt_flag
9013: FROM ben_ler_chg_pl_nip_enrt_f len
9014: WHERE p_pl_id = len.pl_id
9015: AND p_ler_id = len.ler_id
9016: AND p_effective_date BETWEEN len.effective_start_date
9017: AND len.effective_end_date;

Line 9087: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f

9083: --
9084: -- 1 if oipl ben_ler_chg_oipl_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: --