DBA Data[Home] [Help]

APPS.BEN_COBJ_CACHE dependencies on BEN_PTIP_F

Line 699: FROM BEN_PTIP_F TAB1

695: tab1.dpnt_cvg_strt_dt_rl,
696: tab1.dpnt_cvg_end_dt_cd,
697: tab1.dpnt_cvg_end_dt_rl,
698: tab1.postelcn_edit_rl
699: FROM BEN_PTIP_F TAB1
700: WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
701: AND c_effective_date
702: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
703: --

Line 771: FROM BEN_PTIP_F TAB1

767: tab1.dpnt_cvg_strt_dt_rl,
768: tab1.dpnt_cvg_end_dt_cd,
769: tab1.dpnt_cvg_end_dt_rl,
770: tab1.postelcn_edit_rl
771: FROM BEN_PTIP_F TAB1
772: WHERE TAB1.ptip_id = c_ptip_id
773: AND c_effective_date
774: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
775: --