APPS.BEN_COBJ_CACHE dependencies on BEN_PGM_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 529: FROM BEN_PGM_F TAB1

525: tab1.dpnt_cvg_end_dt_cd,
526: tab1.dpnt_cvg_end_dt_rl,
527: tab1.pgm_typ_cd,
528: tab1.all_inelig
529: FROM BEN_PGM_F TAB1
530: WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
531: AND c_effective_date
532: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
533: --

Line 599: FROM BEN_PGM_F TAB1

595: tab1.dpnt_cvg_end_dt_cd,
596: tab1.dpnt_cvg_end_dt_rl,
597: tab1.pgm_typ_cd,
598: tab1.all_inelig
599: FROM BEN_PGM_F TAB1
600: WHERE TAB1.pgm_id = c_pgm_id
601: AND c_effective_date
602: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
603: --