APPS.BEN_COBJ_CACHE dependencies on BEN_OIPL_F

Line 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

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

Line 352: FROM BEN_OIPL_F TAB1

348: ,tab1.rqd_perd_enrt_nenrt_rl
349: ,tab1.actl_prem_id
350: ,tab1.postelcn_edit_rl
351: ,tab1.all_inelig
352: FROM BEN_OIPL_F TAB1
353: WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
354: AND c_effective_date
355: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
356: --

Line 425: FROM BEN_OIPL_F TAB1

421: ,tab1.rqd_perd_enrt_nenrt_rl
422: ,tab1.actl_prem_id
423: ,tab1.postelcn_edit_rl
424: ,tab1.all_inelig
425: FROM BEN_OIPL_F TAB1
426: WHERE TAB1.oipl_id = c_oipl_id
427: AND c_effective_date
428: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
429: --