379: -- END IF;
380:
381: SELECT
382: decode(x_pmt_plan_id,
383: fnd_api.g_miss_num, oldrow.pmt_plan_id,
384: x_pmt_plan_id),
385: decode(x_salesrep_id,
386: fnd_api.g_miss_num, oldrow.salesrep_id,
387: x_salesrep_id),
382: decode(x_pmt_plan_id,
383: fnd_api.g_miss_num, oldrow.pmt_plan_id,
384: x_pmt_plan_id),
385: decode(x_salesrep_id,
386: fnd_api.g_miss_num, oldrow.salesrep_id,
387: x_salesrep_id),
388: decode(x_org_id,
389: fnd_api.g_miss_num, oldrow.org_id,
390: x_org_id),
385: decode(x_salesrep_id,
386: fnd_api.g_miss_num, oldrow.salesrep_id,
387: x_salesrep_id),
388: decode(x_org_id,
389: fnd_api.g_miss_num, oldrow.org_id,
390: x_org_id),
391: decode(x_role_id,
392: fnd_api.g_miss_num, oldrow.role_id,
393: x_role_id),
388: decode(x_org_id,
389: fnd_api.g_miss_num, oldrow.org_id,
390: x_org_id),
391: decode(x_role_id,
392: fnd_api.g_miss_num, oldrow.role_id,
393: x_role_id),
394: decode(x_credit_type_id,
395: fnd_api.g_miss_num, oldrow.credit_type_id ,
396: x_credit_type_id),
391: decode(x_role_id,
392: fnd_api.g_miss_num, oldrow.role_id,
393: x_role_id),
394: decode(x_credit_type_id,
395: fnd_api.g_miss_num, oldrow.credit_type_id ,
396: x_credit_type_id),
397: decode(x_start_date,
398: fnd_api.g_miss_date, oldrow.start_date,
399: x_start_date),
394: decode(x_credit_type_id,
395: fnd_api.g_miss_num, oldrow.credit_type_id ,
396: x_credit_type_id),
397: decode(x_start_date,
398: fnd_api.g_miss_date, oldrow.start_date,
399: x_start_date),
400: decode(x_end_date,
401: fnd_api.g_miss_date, oldrow.end_date,
402: x_end_date),
397: decode(x_start_date,
398: fnd_api.g_miss_date, oldrow.start_date,
399: x_start_date),
400: decode(x_end_date,
401: fnd_api.g_miss_date, oldrow.end_date,
402: x_end_date),
403: decode(x_minimum_amount,
404: fnd_api.g_miss_num, oldrow.minimum_amount,
405: x_minimum_amount),
400: decode(x_end_date,
401: fnd_api.g_miss_date, oldrow.end_date,
402: x_end_date),
403: decode(x_minimum_amount,
404: fnd_api.g_miss_num, oldrow.minimum_amount,
405: x_minimum_amount),
406: decode(x_maximum_amount,
407: fnd_api.g_miss_num, oldrow.maximum_amount,
408: x_maximum_amount),
403: decode(x_minimum_amount,
404: fnd_api.g_miss_num, oldrow.minimum_amount,
405: x_minimum_amount),
406: decode(x_maximum_amount,
407: fnd_api.g_miss_num, oldrow.maximum_amount,
408: x_maximum_amount),
409: decode(x_max_recovery_amount,
410: fnd_api.g_miss_num, oldrow.max_recovery_amount,
411: x_max_recovery_amount),
406: decode(x_maximum_amount,
407: fnd_api.g_miss_num, oldrow.maximum_amount,
408: x_maximum_amount),
409: decode(x_max_recovery_amount,
410: fnd_api.g_miss_num, oldrow.max_recovery_amount,
411: x_max_recovery_amount),
412: decode(x_attribute_category,
413: fnd_api.g_miss_char, oldrow.attribute_category,
414: x_attribute_category),
409: decode(x_max_recovery_amount,
410: fnd_api.g_miss_num, oldrow.max_recovery_amount,
411: x_max_recovery_amount),
412: decode(x_attribute_category,
413: fnd_api.g_miss_char, oldrow.attribute_category,
414: x_attribute_category),
415: decode(x_attribute1,
416: fnd_api.g_miss_char, oldrow.attribute1,
417: x_attribute1),
412: decode(x_attribute_category,
413: fnd_api.g_miss_char, oldrow.attribute_category,
414: x_attribute_category),
415: decode(x_attribute1,
416: fnd_api.g_miss_char, oldrow.attribute1,
417: x_attribute1),
418: decode(x_attribute2,
419: fnd_api.g_miss_char, oldrow.attribute2,
420: x_attribute2),
415: decode(x_attribute1,
416: fnd_api.g_miss_char, oldrow.attribute1,
417: x_attribute1),
418: decode(x_attribute2,
419: fnd_api.g_miss_char, oldrow.attribute2,
420: x_attribute2),
421: decode(x_attribute3,
422: fnd_api.g_miss_char, oldrow.attribute3,
423: x_attribute3),
418: decode(x_attribute2,
419: fnd_api.g_miss_char, oldrow.attribute2,
420: x_attribute2),
421: decode(x_attribute3,
422: fnd_api.g_miss_char, oldrow.attribute3,
423: x_attribute3),
424: decode(x_attribute4,
425: fnd_api.g_miss_char, oldrow.attribute4,
426: x_attribute4),
421: decode(x_attribute3,
422: fnd_api.g_miss_char, oldrow.attribute3,
423: x_attribute3),
424: decode(x_attribute4,
425: fnd_api.g_miss_char, oldrow.attribute4,
426: x_attribute4),
427: decode(x_attribute5,
428: fnd_api.g_miss_char, oldrow.attribute5,
429: x_attribute5),
424: decode(x_attribute4,
425: fnd_api.g_miss_char, oldrow.attribute4,
426: x_attribute4),
427: decode(x_attribute5,
428: fnd_api.g_miss_char, oldrow.attribute5,
429: x_attribute5),
430: decode(x_attribute6,
431: fnd_api.g_miss_char, oldrow.attribute6,
432: x_attribute6),
427: decode(x_attribute5,
428: fnd_api.g_miss_char, oldrow.attribute5,
429: x_attribute5),
430: decode(x_attribute6,
431: fnd_api.g_miss_char, oldrow.attribute6,
432: x_attribute6),
433: decode(x_attribute7,
434: fnd_api.g_miss_char, oldrow.attribute7,
435: x_attribute7),
430: decode(x_attribute6,
431: fnd_api.g_miss_char, oldrow.attribute6,
432: x_attribute6),
433: decode(x_attribute7,
434: fnd_api.g_miss_char, oldrow.attribute7,
435: x_attribute7),
436: decode(x_attribute8,
437: fnd_api.g_miss_char, oldrow.attribute8,
438: x_attribute8),
433: decode(x_attribute7,
434: fnd_api.g_miss_char, oldrow.attribute7,
435: x_attribute7),
436: decode(x_attribute8,
437: fnd_api.g_miss_char, oldrow.attribute8,
438: x_attribute8),
439: decode(x_attribute9,
440: fnd_api.g_miss_char, oldrow.attribute9,
441: x_attribute9),
436: decode(x_attribute8,
437: fnd_api.g_miss_char, oldrow.attribute8,
438: x_attribute8),
439: decode(x_attribute9,
440: fnd_api.g_miss_char, oldrow.attribute9,
441: x_attribute9),
442: decode(x_attribute10,
443: fnd_api.g_miss_char, oldrow.attribute10,
444: x_attribute10),
439: decode(x_attribute9,
440: fnd_api.g_miss_char, oldrow.attribute9,
441: x_attribute9),
442: decode(x_attribute10,
443: fnd_api.g_miss_char, oldrow.attribute10,
444: x_attribute10),
445: decode(x_attribute11,
446: fnd_api.g_miss_char, oldrow.attribute11,
447: x_attribute11),
442: decode(x_attribute10,
443: fnd_api.g_miss_char, oldrow.attribute10,
444: x_attribute10),
445: decode(x_attribute11,
446: fnd_api.g_miss_char, oldrow.attribute11,
447: x_attribute11),
448: decode(x_attribute12,
449: fnd_api.g_miss_char, oldrow.attribute12,
450: x_attribute12),
445: decode(x_attribute11,
446: fnd_api.g_miss_char, oldrow.attribute11,
447: x_attribute11),
448: decode(x_attribute12,
449: fnd_api.g_miss_char, oldrow.attribute12,
450: x_attribute12),
451: decode(x_attribute13,
452: fnd_api.g_miss_char, oldrow.attribute13,
453: x_attribute13),
448: decode(x_attribute12,
449: fnd_api.g_miss_char, oldrow.attribute12,
450: x_attribute12),
451: decode(x_attribute13,
452: fnd_api.g_miss_char, oldrow.attribute13,
453: x_attribute13),
454: decode(x_attribute14,
455: fnd_api.g_miss_char, oldrow.attribute14,
456: x_attribute14),
451: decode(x_attribute13,
452: fnd_api.g_miss_char, oldrow.attribute13,
453: x_attribute13),
454: decode(x_attribute14,
455: fnd_api.g_miss_char, oldrow.attribute14,
456: x_attribute14),
457: decode(x_attribute15,
458: fnd_api.g_miss_char, oldrow.attribute15,
459: x_attribute15),
454: decode(x_attribute14,
455: fnd_api.g_miss_char, oldrow.attribute14,
456: x_attribute14),
457: decode(x_attribute15,
458: fnd_api.g_miss_char, oldrow.attribute15,
459: x_attribute15),
460: decode(x_lock_flag,
461: fnd_api.g_miss_char, oldrow.lock_flag,
462: x_lock_flag)
457: decode(x_attribute15,
458: fnd_api.g_miss_char, oldrow.attribute15,
459: x_attribute15),
460: decode(x_lock_flag,
461: fnd_api.g_miss_char, oldrow.lock_flag,
462: x_lock_flag)
463: INTO
464: l_pmt_plan_id,
465: l_salesrep_id,