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 597: FROM ben_ler_chg_pl_nip_enrt_f len

593: CURSOR c_ler_pl_nip_dflt_cd IS
594: SELECT len.dflt_enrt_cd,
595: len.dflt_enrt_rl,
596: len.dflt_flag
597: FROM ben_ler_chg_pl_nip_enrt_f len
598: WHERE p_pl_id = len.pl_id
599: AND p_ler_id = len.ler_id
600: AND p_effective_date BETWEEN len.effective_start_date
601: AND len.effective_end_date;

Line 675: -- 2 if no pgm ben_ler_chg_pl_nip_enrt_f

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

Line 978: p_pl_id IN ben_ler_chg_pl_nip_enrt_f.pl_id%TYPE,

974: --
975: END;
976: -- end internal determine_dflt_enrt_cd
977: PROCEDURE determine_ben_settings(
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,

Line 979: p_ler_id IN ben_ler_chg_pl_nip_enrt_f.ler_id%TYPE,

975: END;
976: -- end internal determine_dflt_enrt_cd
977: PROCEDURE determine_ben_settings(
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,

Line 1072: FROM ben_ler_chg_pl_nip_enrt_f pl_nip

1068: pl_nip.enrt_rl,
1069: pl_nip.ler_chg_pl_nip_enrt_id,
1070: pl_nip.stl_elig_cant_chg_flag,
1071: pl_nip.tco_chg_enrt_cd
1072: FROM ben_ler_chg_pl_nip_enrt_f pl_nip
1073: WHERE pl_nip.pl_id = p_pl_id
1074: AND pl_nip.ler_id = p_ler_id
1075: AND p_lf_evt_ocrd_dt BETWEEN pl_nip.effective_start_date
1076: AND pl_nip.effective_end_date;

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

Line 1096: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%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;
1099: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
1100: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;

Line 1097: pnip_dflt_flag ben_ler_chg_pl_nip_enrt_f.dflt_flag%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;
1099: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 1098: pnip_enrt_cd ben_ler_chg_pl_nip_enrt_f.enrt_cd%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;
1099: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 1099: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;
1099: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 1100: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_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;
1099: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 1101: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%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;
1099: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 1102: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;

1098: pnip_enrt_cd ben_ler_chg_pl_nip_enrt_f.enrt_cd%TYPE;
1099: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 1103: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;

1099: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 1700: ben_ler_chg_pl_nip_enrt_f pl_nip,

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

Line 8610: FROM ben_ler_chg_pl_nip_enrt_f len

8606: --
8607: CURSOR c_ler_pl_nip_dflt_cd IS
8608: SELECT len.dflt_enrt_cd,
8609: len.dflt_enrt_rl
8610: FROM ben_ler_chg_pl_nip_enrt_f len
8611: WHERE p_pl_id = len.pl_id
8612: AND p_ler_id = len.ler_id
8613: AND p_effective_date BETWEEN len.effective_start_date
8614: AND len.effective_end_date;

Line 8685: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f

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

Line 8687: -- 4.5 if pgm ben_ler_chg_pl_nip_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: --
8691: -- 7 if no pgm ben_pl_f

Line 8874: FROM ben_ler_chg_pl_nip_enrt_f len

8870: CURSOR c_ler_pl_nip_dflt_cd IS
8871: SELECT len.dflt_enrt_cd,
8872: len.dflt_enrt_rl,
8873: len.dflt_flag
8874: FROM ben_ler_chg_pl_nip_enrt_f len
8875: WHERE p_pl_id = len.pl_id
8876: AND p_ler_id = len.ler_id
8877: AND p_effective_date BETWEEN len.effective_start_date
8878: AND len.effective_end_date;

Line 8948: -- 3 if no pgm ben_ler_chg_pl_nip_enrt_f

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
8950: -- 5 if pgm ben_ler_chg_ptip_enrt_f
8951: -- 6 if pgm ben_ler_chg_pgm_enrt_f
8952: --