APPS.BEN_COBJ_CACHE dependencies on BEN_PLIP_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 884: FROM BEN_PLIP_F TAB1

880: tab1.mx_cvg_mlt_incr_num,
881: tab1.mx_cvg_mlt_incr_wcf_num,
882: tab1.postelcn_edit_rl,
883: tab1.all_inelig
884: FROM BEN_PLIP_F TAB1
885: WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
886: AND c_effective_date
887: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
888: --

Line 955: FROM BEN_PLIP_F TAB1

951: tab1.mx_cvg_mlt_incr_num,
952: tab1.mx_cvg_mlt_incr_wcf_num,
953: tab1.postelcn_edit_rl,
954: tab1.all_inelig
955: FROM BEN_PLIP_F TAB1
956: WHERE TAB1.plip_id = c_plip_id
957: AND c_effective_date
958: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
959: --