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_OIPL_ENRT_F

Line 585: FROM ben_ler_chg_oipl_enrt_f leo

581: CURSOR c_ler_oipl_dflt_cd IS
582: SELECT leo.dflt_enrt_cd,
583: leo.dflt_enrt_rl,
584: leo.dflt_flag
585: FROM ben_ler_chg_oipl_enrt_f leo
586: WHERE p_oipl_id = leo.oipl_id
587: AND p_ler_id = leo.ler_id
588: AND p_effective_date BETWEEN leo.effective_start_date
589: AND leo.effective_end_date;

Line 674: -- 1 if oipl ben_ler_chg_oipl_enrt_f

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

Line 984: p_oipl_id IN ben_ler_chg_oipl_enrt_f.oipl_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,
988: p_auto_enrt_mthd_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE,

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

Line 987: p_enrt_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_rl%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,
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,

Line 988: p_auto_enrt_mthd_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%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,
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,

Line 989: p_crnt_enrt_prclds_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%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,
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,

Line 990: p_dflt_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE,

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,
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,

Line 992: p_stl_elig_cant_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%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,
996: p_enrt_cd_level OUT NOCOPY VARCHAR2 ) IS

Line 1012: FROM ben_ler_chg_oipl_enrt_f oipl

1008: oipl.enrt_cd,
1009: oipl.enrt_rl,
1010: oipl.ler_chg_oipl_enrt_id,
1011: oipl.stl_elig_cant_chg_flag
1012: FROM ben_ler_chg_oipl_enrt_f oipl
1013: WHERE oipl.oipl_id = p_oipl_id
1014: AND oipl.ler_id = p_ler_id
1015: AND p_lf_evt_ocrd_dt BETWEEN oipl.effective_start_date
1016: AND oipl.effective_end_date;

Line 1080: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;

1076: AND pl_nip.effective_end_date;
1077: -- ======================
1078: -- define local variables
1079: -- ======================
1080: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
1081: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
1082: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1083: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
1084: oipl_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;

Line 1081: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;

1077: -- ======================
1078: -- define local variables
1079: -- ======================
1080: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
1081: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
1082: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1083: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%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;

Line 1082: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

1078: -- define local variables
1079: -- ======================
1080: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
1081: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
1082: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1083: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%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;

Line 1083: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;

1079: -- ======================
1080: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
1081: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
1082: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1083: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%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;

Line 1084: oipl_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;

1080: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
1081: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
1082: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1083: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%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;

Line 1085: oipl_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;

1081: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
1082: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1083: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%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;

Line 1086: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;

1082: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
1083: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%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;

Line 1087: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;

1083: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%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;

Line 1431: l_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;

1427: --
1428: l_lf_evt_ocrd_dt DATE := NVL(p_lf_evt_ocrd_dt, p_effective_date);
1429: l_lf_evt_ocrd_dt_1 DATE := l_lf_evt_ocrd_dt -
1430: 1;
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;

Line 1432: l_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;

1428: l_lf_evt_ocrd_dt DATE := NVL(p_lf_evt_ocrd_dt, p_effective_date);
1429: l_lf_evt_ocrd_dt_1 DATE := l_lf_evt_ocrd_dt -
1430: 1;
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;

Line 1433: l_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;

1429: l_lf_evt_ocrd_dt_1 DATE := l_lf_evt_ocrd_dt -
1430: 1;
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;

Line 1434: l_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;

1430: 1;
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);

Line 1436: l_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%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);
1440: --

Line 1704: ben_ler_chg_oipl_enrt_f oipl

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
1708: pl_nip.ler_id(+)=decode(dual.dummy,dual.dummy,p_ler_id,dual.dummy) and

Line 8599: FROM ben_ler_chg_oipl_enrt_f leo

8595: --
8596: CURSOR c_ler_oipl_dflt_cd IS
8597: SELECT leo.dflt_enrt_cd,
8598: leo.dflt_enrt_rl
8599: FROM ben_ler_chg_oipl_enrt_f leo
8600: WHERE p_oipl_id = leo.oipl_id
8601: AND p_ler_id = leo.ler_id
8602: AND p_effective_date BETWEEN leo.effective_start_date
8603: AND leo.effective_end_date;

Line 8682: -- 1 if oipl ben_ler_chg_oipl_enrt_f

8678: l_dflt_enrt_cd := NULL;
8679: --
8680: -- Hierarchy
8681: --
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

Line 8862: FROM ben_ler_chg_oipl_enrt_f leo

8858: CURSOR c_ler_oipl_dflt_cd IS
8859: SELECT leo.dflt_enrt_cd,
8860: leo.dflt_enrt_rl,
8861: leo.dflt_flag
8862: FROM ben_ler_chg_oipl_enrt_f leo
8863: WHERE p_oipl_id = leo.oipl_id
8864: AND p_ler_id = leo.ler_id
8865: AND p_effective_date BETWEEN leo.effective_start_date
8866: AND leo.effective_end_date;

Line 8945: -- 1 if oipl ben_ler_chg_oipl_enrt_f

8941: l_dflt_enrt_cd := NULL;
8942: --
8943: -- Hierarchy
8944: --
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