APPS.OKC_ROLE_SOURCE_PUB dependencies on OKC_CONTACT_SOURCES

Line 168: from okc_contact_sources

164: -- Changed the select statement to UNION ALL for performance reasons 08/14/2000
165:
166: cursor c1 is
167: select START_DATE+0.5
168: from okc_contact_sources
169: where RLE_CODE = p_rle_code AND p_rle_code is not null
170: and nvl(end_date,sysdate)>=sysdate
171: UNION ALL
172: select START_DATE+0.5

Line 173: from okc_contact_sources

169: where RLE_CODE = p_rle_code AND p_rle_code is not null
170: and nvl(end_date,sysdate)>=sysdate
171: UNION ALL
172: select START_DATE+0.5
173: from okc_contact_sources
174: where p_rle_code is null
175: and nvl(end_date,sysdate)>=sysdate;
176: d1 date;
177: cursor c2 is

Line 179: -- from okc_contact_sources

175: and nvl(end_date,sysdate)>=sysdate;
176: d1 date;
177: cursor c2 is
178: -- select max(count(start_date))
179: -- from okc_contact_sources
180: -- where RLE_CODE = NVL(p_rle_code,RLE_CODE)
181: -- and d1 between start_date and NVL(end_date,d1)
182: -- group by RLE_CODE, CRO_CODE, buy_or_sell;
183: select count(start_date)

Line 184: from okc_contact_sources

180: -- where RLE_CODE = NVL(p_rle_code,RLE_CODE)
181: -- and d1 between start_date and NVL(end_date,d1)
182: -- group by RLE_CODE, CRO_CODE, buy_or_sell;
183: select count(start_date)
184: from okc_contact_sources
185: where RLE_CODE = p_rle_code and p_rle_code is not null
186: and d1 between start_date and NVL(end_date,d1)
187: group by RLE_CODE, CRO_CODE, buy_or_sell
188: having count(start_date) > 1

Line 191: from okc_contact_sources

187: group by RLE_CODE, CRO_CODE, buy_or_sell
188: having count(start_date) > 1
189: UNION ALL
190: select count(start_date)
191: from okc_contact_sources
192: where p_rle_code is null
193: and d1 between start_date and NVL(end_date,d1)
194: group by RLE_CODE, CRO_CODE, buy_or_sell
195: having count(start_date) > 1;

Line 212: value => 'OKC_CONTACT_SOURCES',

208: name => G_TOO_MANY_SOURCES);
209: FND_MESSAGE.SET_TOKEN(token => 'DATE',
210: value => fnd_date.date_to_chardate(d1));
211: FND_MESSAGE.SET_TOKEN(token => 'SOURCE',
212: value => 'OKC_CONTACT_SOURCES',
213: translate => TRUE);
214: FND_MSG_PUB.add;
215: x_return_status := OKC_API.G_RET_STS_ERROR;
216: exit;