321: CLOSE C;
322:
323: SELECT
324: decode(p_quota_id,
325: fnd_api.g_miss_num, oldrow.quota_id,
326: p_quota_id),
327: decode(p_pay_element_type_id,
328: fnd_api.g_miss_num, oldrow.pay_element_type_id,
329: p_pay_element_type_id),
324: decode(p_quota_id,
325: fnd_api.g_miss_num, oldrow.quota_id,
326: p_quota_id),
327: decode(p_pay_element_type_id,
328: fnd_api.g_miss_num, oldrow.pay_element_type_id,
329: p_pay_element_type_id),
330: decode(p_status,
331: fnd_api.g_miss_char, oldrow.status,
332: p_status),
327: decode(p_pay_element_type_id,
328: fnd_api.g_miss_num, oldrow.pay_element_type_id,
329: p_pay_element_type_id),
330: decode(p_status,
331: fnd_api.g_miss_char, oldrow.status,
332: p_status),
333: decode(p_start_date,
334: fnd_api.g_miss_date, oldrow.start_date,
335: p_start_date),
330: decode(p_status,
331: fnd_api.g_miss_char, oldrow.status,
332: p_status),
333: decode(p_start_date,
334: fnd_api.g_miss_date, oldrow.start_date,
335: p_start_date),
336: decode(p_end_date,
337: fnd_api.g_miss_date, oldrow.end_date,
338: p_end_date),
333: decode(p_start_date,
334: fnd_api.g_miss_date, oldrow.start_date,
335: p_start_date),
336: decode(p_end_date,
337: fnd_api.g_miss_date, oldrow.end_date,
338: p_end_date),
339: decode(p_attribute_category,
340: fnd_api.g_miss_char, oldrow.attribute_category,
341: p_attribute_category),
336: decode(p_end_date,
337: fnd_api.g_miss_date, oldrow.end_date,
338: p_end_date),
339: decode(p_attribute_category,
340: fnd_api.g_miss_char, oldrow.attribute_category,
341: p_attribute_category),
342: decode(p_attribute1,
343: fnd_api.g_miss_char, oldrow.attribute1,
344: p_attribute1),
339: decode(p_attribute_category,
340: fnd_api.g_miss_char, oldrow.attribute_category,
341: p_attribute_category),
342: decode(p_attribute1,
343: fnd_api.g_miss_char, oldrow.attribute1,
344: p_attribute1),
345: decode(p_attribute2,
346: fnd_api.g_miss_char, oldrow.attribute2,
347: p_attribute2),
342: decode(p_attribute1,
343: fnd_api.g_miss_char, oldrow.attribute1,
344: p_attribute1),
345: decode(p_attribute2,
346: fnd_api.g_miss_char, oldrow.attribute2,
347: p_attribute2),
348: decode(p_attribute3,
349: fnd_api.g_miss_char, oldrow.attribute3,
350: p_attribute3),
345: decode(p_attribute2,
346: fnd_api.g_miss_char, oldrow.attribute2,
347: p_attribute2),
348: decode(p_attribute3,
349: fnd_api.g_miss_char, oldrow.attribute3,
350: p_attribute3),
351: decode(p_attribute4,
352: fnd_api.g_miss_char, oldrow.attribute4,
353: p_attribute4),
348: decode(p_attribute3,
349: fnd_api.g_miss_char, oldrow.attribute3,
350: p_attribute3),
351: decode(p_attribute4,
352: fnd_api.g_miss_char, oldrow.attribute4,
353: p_attribute4),
354: decode(p_attribute5,
355: fnd_api.g_miss_char, oldrow.attribute5,
356: p_attribute5),
351: decode(p_attribute4,
352: fnd_api.g_miss_char, oldrow.attribute4,
353: p_attribute4),
354: decode(p_attribute5,
355: fnd_api.g_miss_char, oldrow.attribute5,
356: p_attribute5),
357: decode(p_attribute6,
358: fnd_api.g_miss_char, oldrow.attribute6,
359: p_attribute6),
354: decode(p_attribute5,
355: fnd_api.g_miss_char, oldrow.attribute5,
356: p_attribute5),
357: decode(p_attribute6,
358: fnd_api.g_miss_char, oldrow.attribute6,
359: p_attribute6),
360: decode(p_attribute7,
361: fnd_api.g_miss_char, oldrow.attribute7,
362: p_attribute7),
357: decode(p_attribute6,
358: fnd_api.g_miss_char, oldrow.attribute6,
359: p_attribute6),
360: decode(p_attribute7,
361: fnd_api.g_miss_char, oldrow.attribute7,
362: p_attribute7),
363: decode(p_attribute8,
364: fnd_api.g_miss_char, oldrow.attribute8,
365: p_attribute8),
360: decode(p_attribute7,
361: fnd_api.g_miss_char, oldrow.attribute7,
362: p_attribute7),
363: decode(p_attribute8,
364: fnd_api.g_miss_char, oldrow.attribute8,
365: p_attribute8),
366: decode(p_attribute9,
367: fnd_api.g_miss_char, oldrow.attribute9,
368: p_attribute9),
363: decode(p_attribute8,
364: fnd_api.g_miss_char, oldrow.attribute8,
365: p_attribute8),
366: decode(p_attribute9,
367: fnd_api.g_miss_char, oldrow.attribute9,
368: p_attribute9),
369: decode(p_attribute10,
370: fnd_api.g_miss_char, oldrow.attribute10,
371: p_attribute10),
366: decode(p_attribute9,
367: fnd_api.g_miss_char, oldrow.attribute9,
368: p_attribute9),
369: decode(p_attribute10,
370: fnd_api.g_miss_char, oldrow.attribute10,
371: p_attribute10),
372: decode(p_attribute11,
373: fnd_api.g_miss_char, oldrow.attribute11,
374: p_attribute11),
369: decode(p_attribute10,
370: fnd_api.g_miss_char, oldrow.attribute10,
371: p_attribute10),
372: decode(p_attribute11,
373: fnd_api.g_miss_char, oldrow.attribute11,
374: p_attribute11),
375: decode(p_attribute12,
376: fnd_api.g_miss_char, oldrow.attribute12,
377: p_attribute12),
372: decode(p_attribute11,
373: fnd_api.g_miss_char, oldrow.attribute11,
374: p_attribute11),
375: decode(p_attribute12,
376: fnd_api.g_miss_char, oldrow.attribute12,
377: p_attribute12),
378: decode(p_attribute13,
379: fnd_api.g_miss_char, oldrow.attribute13,
380: p_attribute13),
375: decode(p_attribute12,
376: fnd_api.g_miss_char, oldrow.attribute12,
377: p_attribute12),
378: decode(p_attribute13,
379: fnd_api.g_miss_char, oldrow.attribute13,
380: p_attribute13),
381: decode(p_attribute14,
382: fnd_api.g_miss_char, oldrow.attribute14,
383: p_attribute14),
378: decode(p_attribute13,
379: fnd_api.g_miss_char, oldrow.attribute13,
380: p_attribute13),
381: decode(p_attribute14,
382: fnd_api.g_miss_char, oldrow.attribute14,
383: p_attribute14),
384: decode(p_attribute15,
385: fnd_api.g_miss_char, oldrow.attribute15,
386: p_attribute15)
381: decode(p_attribute14,
382: fnd_api.g_miss_char, oldrow.attribute14,
383: p_attribute14),
384: decode(p_attribute15,
385: fnd_api.g_miss_char, oldrow.attribute15,
386: p_attribute15)
387: INTO
388: l_quota_id,
389: l_pay_element_type_id,