DBA Data[Home] [Help]

APPS.XTR_RATE_CHANGE dependencies on XTR_TERM_ACTIONS_V

Line 237: update XTR_term_actions_V

233:
234: end if;
235:
236: /* AW 7/15 Bug 914129 Should not allow to update previous actions for this deal !!!
237: update XTR_term_actions_V
238: set NEW_INTEREST_RATE = p_new_interest_rate,
239: EFFECTIVE_FROM_DATE = sysdate,
240: CREATED_ON = SYSDATE,
241: CREATED_BY = '-1'

Line 245: insert into XTR_term_actions_V(

241: CREATED_BY = '-1'
242: where deal_no = deal.DEAL_NO;
243: if SQL%NOTFOUND then
244: */
245: insert into XTR_term_actions_V(
246: DEAL_NO,
247: NEW_INTEREST_RATE,
248: EFFECTIVE_FROM_DATE,
249: CREATED_ON,