[Home] [Help]
22: 115.6 22-May-01 mhoyes - Upgraded comp object caches to be context
23: sensitive. Hence when the refresh routine is
24: not called then the cache will use SQL.
25: 115.7 26-Jul-01 ikasire Bug 1895874 adding nip_dflt_flag column
26: to ben_pl_f table
27: 115.10 29-Nov-05 abparekh Bug 4766118 - Added ALWS_QDRO_FLAG to G_PL_INST_ROW
28: 115.11 13-Mar-06 kmahendr bug#5082245 - added svgs_pl_flag to g_pl_inst_row
29: 115.12 27-Dec-11 velvanop Bug 12558830: Creating Ineligible Flag for Compensation Object. ALL_INELIG column ben_pl_f,ben_pgm_f,ben_ptip_f,ben_plip_f,ben_oipl_f
30: needs to cached to check whether the comp object is Ineligible or not.
25: 115.7 26-Jul-01 ikasire Bug 1895874 adding nip_dflt_flag column
26: to ben_pl_f table
27: 115.10 29-Nov-05 abparekh Bug 4766118 - Added ALWS_QDRO_FLAG to G_PL_INST_ROW
28: 115.11 13-Mar-06 kmahendr bug#5082245 - added svgs_pl_flag to g_pl_inst_row
29: 115.12 27-Dec-11 velvanop Bug 12558830: Creating Ineligible Flag for Compensation Object. ALL_INELIG column ben_pl_f,ben_pgm_f,ben_ptip_f,ben_plip_f,ben_oipl_f
30: needs to cached to check whether the comp object is Ineligible or not.
31: -----------------------------------------------------------------------------
32: */
33: --
1080: tab1.dpnt_cvd_by_othr_apls_flag,
1081: tab1.nip_dflt_flag,
1082: tab1.svgs_pl_flag,
1083: tab1.all_inelig
1084: FROM BEN_PL_F TAB1
1085: WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
1086: AND c_effective_date
1087: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
1088: --
1175: tab1.dpnt_cvd_by_othr_apls_flag,
1176: tab1.nip_dflt_flag,
1177: tab1.SVGS_PL_FLAG,
1178: tab1.all_inelig
1179: FROM BEN_PL_F TAB1
1180: WHERE TAB1.pl_id = c_pl_id
1181: AND c_effective_date
1182: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
1183: --