APPS.XTR_MISC_P dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 774: from XTR_ROLLOVER_TRANSACTIONS_V a,

770: 'TMM',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
771: 'RTMM',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
772: 'DEB',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
773: a.balance_out)),0) gross_amount
774: from XTR_ROLLOVER_TRANSACTIONS_V a,
775: XTR_DEALS_V b
776: where a.company_code like p_company_code and a.currency like p_currency
777: and a.status_code='CURRENT'
778: and a.portfolio_code like p_portfolio_code

Line 1086: update XTR_ROLLOVER_TRANSACTIONS

1082: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1083: where DEAL_NO = p_deal_no
1084: and DEAL_TYPE = p_deal_type;
1085:
1086: update XTR_ROLLOVER_TRANSACTIONS
1087: set DUAL_AUTHORISATION_BY = p_validated_by,
1088: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1089: where DEAL_NUMBER = p_deal_no
1090: and DEAL_TYPE = p_deal_type

Line 1109: update XTR_ROLLOVER_TRANSACTIONS

1105: and TRANSACTION_NUMBER = p_trans_no
1106: and DEAL_TYPE = p_deal_type;
1107:
1108: elsif p_action_type = 'NEW_STOCK_CASH_DIVIDEND' then -- stock cash dividend
1109: update XTR_ROLLOVER_TRANSACTIONS
1110: set DUAL_AUTHORISATION_BY = p_validated_by,
1111: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1112: where DEAL_NUMBER = p_deal_no
1113: and TRANSACTION_NUMBER = p_trans_no

Line 1149: update XTR_ROLLOVER_TRANSACTIONS

1145: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1146: where DEAL_NO = p_deal_no
1147: and DEAL_TYPE = p_deal_type;
1148:
1149: update XTR_ROLLOVER_TRANSACTIONS
1150: set DUAL_AUTHORISATION_BY = p_validated_by,
1151: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1152: where DEAL_NUMBER = p_deal_no
1153: and DEAL_TYPE = p_deal_type;

Line 1171: update XTR_ROLLOVER_TRANSACTIONS

1167: elsif c.EFFECTIVE_FROM_DATE is not null then
1168: l_date :=c.EFFECTIVE_FROM_DATE;
1169: end if;
1170:
1171: update XTR_ROLLOVER_TRANSACTIONS
1172: set DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate),
1173: DUAL_AUTHORISATION_BY = p_validated_by
1174: where DEAL_NUMBER = p_deal_no
1175: and START_DATE >= l_date

Line 1181: update XTR_ROLLOVER_TRANSACTIONS

1177:
1178: end if;
1179: -- add on 01 July 98
1180: elsif p_deal_type ='ONC' then
1181: update XTR_ROLLOVER_TRANSACTIONS
1182: set DUAL_AUTHORISATION_BY = p_validated_by,
1183: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1184: where DEAL_NUMBER = p_deal_no
1185: and TRANSACTION_NUMBER = p_trans_no