75: select DECODE(max(dummy),
76: '', 'N',
77: 'Y')
78: INTO l_sql_result
79: FROM dual
80: WHERE
81: (
82: p_old_cma_rec.credit_memo_amount_id ||
83: p_old_cma_rec.last_updated_by ||
1222: *---------------------------*/
1223:
1224: SELECT AR_CREDIT_MEMO_AMOUNTS_S.NEXTVAL
1225: INTO l_credit_memo_amount_id
1226: FROM DUAL;
1227:
1228:
1229: /*-------------------*
1230: | Insert the record |