APPS.ARI_DB_UTILITIES dependencies on DUAL

Line 244: from dual ;

240: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
241: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
242: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
243: ) into p_bucket_status_code0
244: from dual ;
245:
246: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
247: END IF;
248:

Line 257: from dual ;

253: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
254: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
255: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
256: ) into p_bucket_status_code1
257: from dual ;
258:
259: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
260: END IF;
261:

Line 270: from dual ;

266: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
267: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
268: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
269: ) into p_bucket_status_code2
270: from dual ;
271:
272: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
273: END IF;
274:

Line 283: from dual ;

279: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
280: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
281: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
282: ) into p_bucket_status_code3
283: from dual ;
284:
285: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
286: END IF;
287:

Line 296: from dual ;

292: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
293: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
294: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
295: ) into p_bucket_status_code4
296: from dual ;
297:
298: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
299: END IF;
300:

Line 309: from dual ;

305: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
306: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
307: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
308: ) into p_bucket_status_code5
309: from dual ;
310:
311: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
312: END IF;
313:

Line 322: from dual ;

318: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
319: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
320: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
321: ) into p_bucket_status_code6
322: from dual ;
323:
324: END IF;
325:
326: CLOSE c_sel_bucket_data;