DBA Data[Home] [Help]

APPS.XTR_MISC_P dependencies on XTR_TERM_ACTIONS

Line 916: from XTR_TERM_ACTIONS

912: p_validated_by IN VARCHAR2) is
913: --
914: cursor GET_DATE is
915: select INCREASE_EFFECTIVE_FROM_DATE,FROM_START_DATE,EFFECTIVE_FROM_DATE
916: from XTR_TERM_ACTIONS
917: where DEAL_NO = p_deal_no;
918:
919: -- bug #1295341 jhung
920: cursor IRS_OTHER_DEAL is

Line 1143: update XTR_TERM_ACTIONS

1139: where DEAL_NUMBER = p_deal_no
1140: and DEAL_TYPE = p_deal_type;
1141:
1142: else
1143: update XTR_TERM_ACTIONS
1144: set DUAL_AUTHORISATION_BY = p_validated_by,
1145: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1146: where DEAL_NO = p_deal_no;
1147: open get_date;