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 607: FROM ben_ler_chg_plip_enrt_f lep

603: CURSOR c_ler_plip_dflt_cd IS
604: SELECT lep.dflt_enrt_cd,
605: lep.dflt_enrt_rl,
606: lep.dflt_flag
607: FROM ben_ler_chg_plip_enrt_f lep
608: WHERE p_plip_id = lep.plip_id
609: AND p_ler_id = lep.ler_id
610: AND p_effective_date BETWEEN lep.effective_start_date
611: AND lep.effective_end_date;

Line 676: -- 3 if pgm ben_ler_chg_plip_enrt_f

672: -- Hierarchy
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)

Line 983: p_plip_id IN ben_ler_chg_plip_enrt_f.plip_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,
986: p_enrt_cd OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE,
987: p_enrt_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE,

Line 1056: FROM ben_ler_chg_plip_enrt_f plip

1052: plip.enrt_rl,
1053: plip.ler_chg_plip_enrt_id,
1054: plip.stl_elig_cant_chg_flag,
1055: plip.tco_chg_enrt_cd
1056: FROM ben_ler_chg_plip_enrt_f plip
1057: WHERE plip.plip_id = p_plip_id
1058: AND plip.ler_id = p_ler_id
1059: AND p_lf_evt_ocrd_dt BETWEEN plip.effective_start_date
1060: AND plip.effective_end_date;

Line 1104: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;

1100: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;
1101: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
1102: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1103: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
1104: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
1105: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1106: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
1107: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
1108: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;

Line 1105: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

1101: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
1102: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1103: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
1104: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
1105: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1106: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
1107: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
1108: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
1109: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;

Line 1106: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;

1102: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
1103: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
1104: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
1105: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1106: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
1107: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
1108: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1107: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;

1103: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
1104: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
1105: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1106: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
1107: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
1108: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1108: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;

1104: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
1105: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1106: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
1107: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
1108: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1109: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;

1105: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1106: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
1107: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
1108: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1110: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;

1106: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
1107: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
1108: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%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;

Line 1111: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;

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

Line 1112: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;

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

Line 1703: ben_ler_chg_plip_enrt_f plip,

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

Line 8619: FROM ben_ler_chg_plip_enrt_f lep

8615: --
8616: CURSOR c_ler_plip_dflt_cd IS
8617: SELECT lep.dflt_enrt_cd,
8618: lep.dflt_enrt_rl
8619: FROM ben_ler_chg_plip_enrt_f lep
8620: WHERE p_plip_id = lep.plip_id
8621: AND p_ler_id = lep.ler_id
8622: AND p_effective_date BETWEEN lep.effective_start_date
8623: AND lep.effective_end_date;

Line 8686: -- 4 if pgm ben_ler_chg_plip_enrt_f

8682: -- 1 if oipl ben_ler_chg_oipl_enrt_f
8683: -- 2 if oipl ben_oipl_f (from cache)
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: --

Line 8884: FROM ben_ler_chg_plip_enrt_f lep

8880: CURSOR c_ler_plip_dflt_cd IS
8881: SELECT lep.dflt_enrt_cd,
8882: lep.dflt_enrt_rl,
8883: lep.dflt_flag
8884: FROM ben_ler_chg_plip_enrt_f lep
8885: WHERE p_plip_id = lep.plip_id
8886: AND p_ler_id = lep.ler_id
8887: AND p_effective_date BETWEEN lep.effective_start_date
8888: AND lep.effective_end_date;

Line 8949: -- 4 if pgm ben_ler_chg_plip_enrt_f

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