DBA Data[Home] [Help]

APPS.BEN_COBJ_CACHE dependencies on BEN_OIPLIP_F

Line 58: FROM BEN_OIPLIP_F TAB1

54: is
55: SELECT TAB1.OIPLIP_ID,
56: TAB1.PLIP_ID,
57: TAB1.OIPL_ID
58: FROM BEN_OIPLIP_F TAB1
59: WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
60: AND c_effective_date
61: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
62: --

Line 107: FROM BEN_OIPLIP_F TAB1

103: is
104: SELECT TAB1.OIPLIP_ID,
105: TAB1.PLIP_ID,
106: TAB1.OIPL_ID
107: FROM BEN_OIPLIP_F TAB1
108: WHERE TAB1.oiplip_id = c_oiplip_id
109: AND c_effective_date
110: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
111: --