DBA Data[Home] [Help]

APPS.XTR_MISC_P dependencies on XTR_TERM_ACTIONS

Line 929: from XTR_TERM_ACTIONS

925: p_validated_by IN VARCHAR2) is
926: --
927: cursor GET_DATE is
928: select INCREASE_EFFECTIVE_FROM_DATE,FROM_START_DATE,EFFECTIVE_FROM_DATE
929: from XTR_TERM_ACTIONS
930: where DEAL_NO = p_deal_no;
931:
932: -- bug #1295341 jhung
933: cursor IRS_OTHER_DEAL is

Line 1156: update XTR_TERM_ACTIONS

1152: where DEAL_NUMBER = p_deal_no
1153: and DEAL_TYPE = p_deal_type;
1154:
1155: else
1156: update XTR_TERM_ACTIONS
1157: set DUAL_AUTHORISATION_BY = p_validated_by,
1158: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1159: where DEAL_NO = p_deal_no;
1160: open get_date;