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 625: FROM ben_ler_chg_pgm_enrt_f lep

621: --
622: CURSOR c_ler_pgm_dflt_cd IS
623: SELECT lep.dflt_enrt_cd,
624: lep.dflt_enrt_rl
625: FROM ben_ler_chg_pgm_enrt_f lep
626: WHERE p_pgm_id = lep.pgm_id
627: AND p_ler_id = lep.ler_id
628: AND p_effective_date BETWEEN lep.effective_start_date
629: AND lep.effective_end_date;

Line 678: -- 5 if pgm ben_ler_chg_pgm_enrt_f

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)
681:
682: -- 7 if no pgm ben_pl_f

Line 982: p_pgm_id IN ben_ler_chg_pgm_enrt_f.pgm_id%TYPE,

978: p_pl_id IN ben_ler_chg_pl_nip_enrt_f.pl_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,

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

987: p_enrt_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE,
988: p_auto_enrt_mthd_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE,
989: p_crnt_enrt_prclds_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE,
990: p_dflt_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE,
991: p_enrt_mthd_cd OUT NOCOPY ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE,
992: p_stl_elig_cant_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE,
993: p_tco_chg_enrt_cd OUT NOCOPY ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE,
994: p_ler_chg_oipl_found_flag OUT NOCOPY VARCHAR2,
995: p_ler_chg_found_flag OUT NOCOPY VARCHAR2,

Line 1026: FROM ben_ler_chg_pgm_enrt_f pgm

1022: pgm.enrt_mthd_cd,
1023: pgm.enrt_rl,
1024: pgm.ler_chg_pgm_enrt_id,
1025: pgm.stl_elig_cant_chg_flag
1026: FROM ben_ler_chg_pgm_enrt_f pgm
1027: WHERE pgm.pgm_id = p_pgm_id
1028: AND pgm.ler_id = p_ler_id
1029: AND p_lf_evt_ocrd_dt BETWEEN pgm.effective_start_date
1030: AND pgm.effective_end_date;

Line 1088: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;

1084: oipl_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;
1085: oipl_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;
1086: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;
1087: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1088: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1089: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1090: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1091: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1092: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;

Line 1089: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

1085: oipl_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;
1086: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;
1087: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1088: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1089: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1090: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1091: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1092: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1093: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;

Line 1090: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;

1086: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;
1087: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1088: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1089: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1090: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1091: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1092: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1093: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1094: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;

Line 1091: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;

1087: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1088: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1089: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1090: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1091: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1092: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1093: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1094: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
1095: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;

Line 1092: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;

1088: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
1089: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1090: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1091: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1092: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1093: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1094: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
1095: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
1096: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

Line 1093: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;

1089: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1090: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1091: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1092: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1093: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1094: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
1095: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
1096: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1097: pnip_dflt_flag ben_ler_chg_pl_nip_enrt_f.dflt_flag%TYPE;

Line 1094: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;

1090: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
1091: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1092: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
1093: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
1094: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
1095: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
1096: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1097: pnip_dflt_flag ben_ler_chg_pl_nip_enrt_f.dflt_flag%TYPE;
1098: pnip_enrt_cd ben_ler_chg_pl_nip_enrt_f.enrt_cd%TYPE;

Line 1435: l_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;

1431: l_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;
1432: l_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;
1433: l_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
1434: l_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
1435: l_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
1436: l_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
1437: l_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
1438: l_ler_chg_oipl_found_flag VARCHAR2(30);
1439: l_ler_chg_found_flag VARCHAR2(30);

Line 1701: ben_ler_chg_pgm_enrt_f pgm,

1697: nvl(ptip.crnt_enrt_prclds_chg_flag,
1698: pgm.crnt_enrt_prclds_chg_flag)))) crnt_enrt_prclds_chg_flag
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

Line 8637: FROM ben_ler_chg_pgm_enrt_f lep

8633: --
8634: CURSOR c_ler_pgm_dflt_cd IS
8635: SELECT lep.dflt_enrt_cd,
8636: lep.dflt_enrt_rl
8637: FROM ben_ler_chg_pgm_enrt_f lep
8638: WHERE p_pgm_id = lep.pgm_id
8639: AND p_ler_id = lep.ler_id
8640: AND p_effective_date BETWEEN lep.effective_start_date
8641: AND lep.effective_end_date;

Line 8689: -- 6 if pgm ben_ler_chg_pgm_enrt_f

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: --
8691: -- 7 if no pgm ben_pl_f
8692: -- 8 if pgm ben_plip_f
8693: -- 9 if pgm ben_ptip_f

Line 8902: FROM ben_ler_chg_pgm_enrt_f lep

8898: --
8899: CURSOR c_ler_pgm_dflt_cd IS
8900: SELECT lep.dflt_enrt_cd,
8901: lep.dflt_enrt_rl
8902: FROM ben_ler_chg_pgm_enrt_f lep
8903: WHERE p_pgm_id = lep.pgm_id
8904: AND p_ler_id = lep.ler_id
8905: AND p_effective_date BETWEEN lep.effective_start_date
8906: AND lep.effective_end_date;

Line 8951: -- 6 if pgm ben_ler_chg_pgm_enrt_f

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
8954: -- 8 if pgm ben_plip_f
8955: -- 9 if pgm ben_ptip_f