DBA Data[Home] [Help]

APPS.BEN_COBJ_CACHE dependencies on BEN_PTIP_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 706: FROM BEN_PTIP_F TAB1

702: tab1.dpnt_cvg_end_dt_cd,
703: tab1.dpnt_cvg_end_dt_rl,
704: tab1.postelcn_edit_rl,
705: tab1.all_inelig
706: FROM BEN_PTIP_F TAB1
707: WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
708: AND c_effective_date
709: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
710: --

Line 779: FROM BEN_PTIP_F TAB1

775: tab1.dpnt_cvg_end_dt_cd,
776: tab1.dpnt_cvg_end_dt_rl,
777: tab1.postelcn_edit_rl,
778: tab1.all_inelig
779: FROM BEN_PTIP_F TAB1
780: WHERE TAB1.ptip_id = c_ptip_id
781: AND c_effective_date
782: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
783: --