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_PLIP_ENRT_F

Line 634: FROM ben_ler_chg_plip_enrt_f lep

630: CURSOR c_ler_plip_dflt_cd IS
631: SELECT lep.dflt_enrt_cd,
632: lep.dflt_enrt_rl,
633: lep.dflt_flag
634: FROM ben_ler_chg_plip_enrt_f lep
635: WHERE p_plip_id = lep.plip_id
636: AND p_ler_id = lep.ler_id
637: AND p_effective_date BETWEEN lep.effective_start_date
638: AND lep.effective_end_date;

Line 703: -- 3 if pgm ben_ler_chg_plip_enrt_f

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

Line 1010: p_plip_id IN ben_ler_chg_plip_enrt_f.plip_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,
1014: p_enrt_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE,

Line 1083: FROM ben_ler_chg_plip_enrt_f plip

1079: plip.enrt_rl,
1080: plip.ler_chg_plip_enrt_id,
1081: plip.stl_elig_cant_chg_flag,
1082: plip.tco_chg_enrt_cd
1083: FROM ben_ler_chg_plip_enrt_f plip
1084: WHERE plip.plip_id = p_plip_id
1085: AND plip.ler_id = p_ler_id
1086: AND p_lf_evt_ocrd_dt BETWEEN plip.effective_start_date
1087: AND plip.effective_end_date;

Line 1131: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%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;
1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;

Line 1132: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%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;
1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
1136: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;

Line 1133: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%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;
1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1134: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%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;
1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_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;
1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1136: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_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;
1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1137: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%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;
1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1138: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;

1134: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1139: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;

1135: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1730: ben_ler_chg_plip_enrt_f plip,

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
1734: pl_nip.business_group_id(+)=p_business_group_id and

Line 8758: FROM ben_ler_chg_plip_enrt_f lep

8754: --
8755: CURSOR c_ler_plip_dflt_cd IS
8756: SELECT lep.dflt_enrt_cd,
8757: lep.dflt_enrt_rl
8758: FROM ben_ler_chg_plip_enrt_f lep
8759: WHERE p_plip_id = lep.plip_id
8760: AND p_ler_id = lep.ler_id
8761: AND p_effective_date BETWEEN lep.effective_start_date
8762: AND lep.effective_end_date;

Line 8825: -- 4 if pgm ben_ler_chg_plip_enrt_f

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

Line 9023: FROM ben_ler_chg_plip_enrt_f lep

9019: CURSOR c_ler_plip_dflt_cd IS
9020: SELECT lep.dflt_enrt_cd,
9021: lep.dflt_enrt_rl,
9022: lep.dflt_flag
9023: FROM ben_ler_chg_plip_enrt_f lep
9024: WHERE p_plip_id = lep.plip_id
9025: AND p_ler_id = lep.ler_id
9026: AND p_effective_date BETWEEN lep.effective_start_date
9027: AND lep.effective_end_date;

Line 9088: -- 4 if pgm ben_ler_chg_plip_enrt_f

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