52: is
53: SELECT TAB1.OIPLIP_ID,
54: TAB1.PLIP_ID,
55: TAB1.OIPL_ID
56: FROM BEN_OIPLIP_F TAB1
57: WHERE TAB1.BUSINESS_GROUP_ID = c_business_group_id
58: AND c_effective_date
59: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
60: --
101: is
102: SELECT TAB1.OIPLIP_ID,
103: TAB1.PLIP_ID,
104: TAB1.OIPL_ID
105: FROM BEN_OIPLIP_F TAB1
106: WHERE TAB1.oiplip_id = c_oiplip_id
107: AND c_effective_date
108: BETWEEN TAB1.EFFECTIVE_START_DATE AND TAB1.EFFECTIVE_END_DATE;
109: --