338: CLOSE C;
339:
340: SELECT
341: decode(p_element_input_id,
342: fnd_api.g_miss_num, oldrow.element_input_id,
343: p_element_input_id),
344: decode(p_quota_pay_element_id,
345: fnd_api.g_miss_num, oldrow.quota_pay_element_id,
346: p_quota_pay_element_id),
341: decode(p_element_input_id,
342: fnd_api.g_miss_num, oldrow.element_input_id,
343: p_element_input_id),
344: decode(p_quota_pay_element_id,
345: fnd_api.g_miss_num, oldrow.quota_pay_element_id,
346: p_quota_pay_element_id),
347: decode(p_element_type_id,
348: fnd_api.g_miss_num, oldrow.element_type_id,
349: p_element_type_id),
344: decode(p_quota_pay_element_id,
345: fnd_api.g_miss_num, oldrow.quota_pay_element_id,
346: p_quota_pay_element_id),
347: decode(p_element_type_id,
348: fnd_api.g_miss_num, oldrow.element_type_id,
349: p_element_type_id),
350: decode(p_tab_object_id,
351: fnd_api.g_miss_num, oldrow.tab_object_id,
352: p_tab_object_id),
347: decode(p_element_type_id,
348: fnd_api.g_miss_num, oldrow.element_type_id,
349: p_element_type_id),
350: decode(p_tab_object_id,
351: fnd_api.g_miss_num, oldrow.tab_object_id,
352: p_tab_object_id),
353: decode(p_col_object_id,
354: fnd_api.g_miss_num, oldrow.col_object_id,
355: p_col_object_id),
350: decode(p_tab_object_id,
351: fnd_api.g_miss_num, oldrow.tab_object_id,
352: p_tab_object_id),
353: decode(p_col_object_id,
354: fnd_api.g_miss_num, oldrow.col_object_id,
355: p_col_object_id),
356: decode(p_line_number,
357: fnd_api.g_miss_num, oldrow.line_number,
358: p_line_number),
353: decode(p_col_object_id,
354: fnd_api.g_miss_num, oldrow.col_object_id,
355: p_col_object_id),
356: decode(p_line_number,
357: fnd_api.g_miss_num, oldrow.line_number,
358: p_line_number),
359: decode(p_start_date,
360: fnd_api.g_miss_date, oldrow.start_date,
361: p_start_date),
356: decode(p_line_number,
357: fnd_api.g_miss_num, oldrow.line_number,
358: p_line_number),
359: decode(p_start_date,
360: fnd_api.g_miss_date, oldrow.start_date,
361: p_start_date),
362: decode(p_end_date,
363: fnd_api.g_miss_date, oldrow.end_date,
364: p_end_Date),
359: decode(p_start_date,
360: fnd_api.g_miss_date, oldrow.start_date,
361: p_start_date),
362: decode(p_end_date,
363: fnd_api.g_miss_date, oldrow.end_date,
364: p_end_Date),
365: decode(p_attribute_category,
366: fnd_api.g_miss_char, oldrow.attribute_category,
367: p_attribute_category),
362: decode(p_end_date,
363: fnd_api.g_miss_date, oldrow.end_date,
364: p_end_Date),
365: decode(p_attribute_category,
366: fnd_api.g_miss_char, oldrow.attribute_category,
367: p_attribute_category),
368: decode(p_attribute1,
369: fnd_api.g_miss_char, oldrow.attribute1,
370: p_attribute1),
365: decode(p_attribute_category,
366: fnd_api.g_miss_char, oldrow.attribute_category,
367: p_attribute_category),
368: decode(p_attribute1,
369: fnd_api.g_miss_char, oldrow.attribute1,
370: p_attribute1),
371: decode(p_attribute2,
372: fnd_api.g_miss_char, oldrow.attribute2,
373: p_attribute2),
368: decode(p_attribute1,
369: fnd_api.g_miss_char, oldrow.attribute1,
370: p_attribute1),
371: decode(p_attribute2,
372: fnd_api.g_miss_char, oldrow.attribute2,
373: p_attribute2),
374: decode(p_attribute3,
375: fnd_api.g_miss_char, oldrow.attribute3,
376: p_attribute3),
371: decode(p_attribute2,
372: fnd_api.g_miss_char, oldrow.attribute2,
373: p_attribute2),
374: decode(p_attribute3,
375: fnd_api.g_miss_char, oldrow.attribute3,
376: p_attribute3),
377: decode(p_attribute4,
378: fnd_api.g_miss_char, oldrow.attribute4,
379: p_attribute4),
374: decode(p_attribute3,
375: fnd_api.g_miss_char, oldrow.attribute3,
376: p_attribute3),
377: decode(p_attribute4,
378: fnd_api.g_miss_char, oldrow.attribute4,
379: p_attribute4),
380: decode(p_attribute5,
381: fnd_api.g_miss_char, oldrow.attribute5,
382: p_attribute5),
377: decode(p_attribute4,
378: fnd_api.g_miss_char, oldrow.attribute4,
379: p_attribute4),
380: decode(p_attribute5,
381: fnd_api.g_miss_char, oldrow.attribute5,
382: p_attribute5),
383: decode(p_attribute6,
384: fnd_api.g_miss_char, oldrow.attribute6,
385: p_attribute6),
380: decode(p_attribute5,
381: fnd_api.g_miss_char, oldrow.attribute5,
382: p_attribute5),
383: decode(p_attribute6,
384: fnd_api.g_miss_char, oldrow.attribute6,
385: p_attribute6),
386: decode(p_attribute7,
387: fnd_api.g_miss_char, oldrow.attribute7,
388: p_attribute7),
383: decode(p_attribute6,
384: fnd_api.g_miss_char, oldrow.attribute6,
385: p_attribute6),
386: decode(p_attribute7,
387: fnd_api.g_miss_char, oldrow.attribute7,
388: p_attribute7),
389: decode(p_attribute8,
390: fnd_api.g_miss_char, oldrow.attribute8,
391: p_attribute8),
386: decode(p_attribute7,
387: fnd_api.g_miss_char, oldrow.attribute7,
388: p_attribute7),
389: decode(p_attribute8,
390: fnd_api.g_miss_char, oldrow.attribute8,
391: p_attribute8),
392: decode(p_attribute9,
393: fnd_api.g_miss_char, oldrow.attribute9,
394: p_attribute9),
389: decode(p_attribute8,
390: fnd_api.g_miss_char, oldrow.attribute8,
391: p_attribute8),
392: decode(p_attribute9,
393: fnd_api.g_miss_char, oldrow.attribute9,
394: p_attribute9),
395: decode(p_attribute10,
396: fnd_api.g_miss_char, oldrow.attribute10,
397: p_attribute10),
392: decode(p_attribute9,
393: fnd_api.g_miss_char, oldrow.attribute9,
394: p_attribute9),
395: decode(p_attribute10,
396: fnd_api.g_miss_char, oldrow.attribute10,
397: p_attribute10),
398: decode(p_attribute11,
399: fnd_api.g_miss_char, oldrow.attribute11,
400: p_attribute11),
395: decode(p_attribute10,
396: fnd_api.g_miss_char, oldrow.attribute10,
397: p_attribute10),
398: decode(p_attribute11,
399: fnd_api.g_miss_char, oldrow.attribute11,
400: p_attribute11),
401: decode(p_attribute12,
402: fnd_api.g_miss_char, oldrow.attribute12,
403: p_attribute12),
398: decode(p_attribute11,
399: fnd_api.g_miss_char, oldrow.attribute11,
400: p_attribute11),
401: decode(p_attribute12,
402: fnd_api.g_miss_char, oldrow.attribute12,
403: p_attribute12),
404: decode(p_attribute13,
405: fnd_api.g_miss_char, oldrow.attribute13,
406: p_attribute13),
401: decode(p_attribute12,
402: fnd_api.g_miss_char, oldrow.attribute12,
403: p_attribute12),
404: decode(p_attribute13,
405: fnd_api.g_miss_char, oldrow.attribute13,
406: p_attribute13),
407: decode(p_attribute14,
408: fnd_api.g_miss_char, oldrow.attribute14,
409: p_attribute14),
404: decode(p_attribute13,
405: fnd_api.g_miss_char, oldrow.attribute13,
406: p_attribute13),
407: decode(p_attribute14,
408: fnd_api.g_miss_char, oldrow.attribute14,
409: p_attribute14),
410: decode(p_attribute15,
411: fnd_api.g_miss_char, oldrow.attribute15,
412: p_attribute15)
407: decode(p_attribute14,
408: fnd_api.g_miss_char, oldrow.attribute14,
409: p_attribute14),
410: decode(p_attribute15,
411: fnd_api.g_miss_char, oldrow.attribute15,
412: p_attribute15)
413: INTO
414: l_element_input_id,
415: l_quota_pay_element_id,