APPS.XTR_MISC_P dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 761: from XTR_ROLLOVER_TRANSACTIONS_V a,

757: 'TMM',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
758: 'RTMM',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
759: 'DEB',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
760: a.balance_out)),0) gross_amount
761: from XTR_ROLLOVER_TRANSACTIONS_V a,
762: XTR_DEALS_V b
763: where a.company_code like p_company_code and a.currency like p_currency
764: and a.status_code='CURRENT'
765: and a.portfolio_code like p_portfolio_code

Line 1073: update XTR_ROLLOVER_TRANSACTIONS

1069: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1070: where DEAL_NO = p_deal_no
1071: and DEAL_TYPE = p_deal_type;
1072:
1073: update XTR_ROLLOVER_TRANSACTIONS
1074: set DUAL_AUTHORISATION_BY = p_validated_by,
1075: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1076: where DEAL_NUMBER = p_deal_no
1077: and DEAL_TYPE = p_deal_type

Line 1096: update XTR_ROLLOVER_TRANSACTIONS

1092: and TRANSACTION_NUMBER = p_trans_no
1093: and DEAL_TYPE = p_deal_type;
1094:
1095: elsif p_action_type = 'NEW_STOCK_CASH_DIVIDEND' then -- stock cash dividend
1096: update XTR_ROLLOVER_TRANSACTIONS
1097: set DUAL_AUTHORISATION_BY = p_validated_by,
1098: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1099: where DEAL_NUMBER = p_deal_no
1100: and TRANSACTION_NUMBER = p_trans_no

Line 1136: update XTR_ROLLOVER_TRANSACTIONS

1132: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1133: where DEAL_NO = p_deal_no
1134: and DEAL_TYPE = p_deal_type;
1135:
1136: update XTR_ROLLOVER_TRANSACTIONS
1137: set DUAL_AUTHORISATION_BY = p_validated_by,
1138: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1139: where DEAL_NUMBER = p_deal_no
1140: and DEAL_TYPE = p_deal_type;

Line 1158: update XTR_ROLLOVER_TRANSACTIONS

1154: elsif c.EFFECTIVE_FROM_DATE is not null then
1155: l_date :=c.EFFECTIVE_FROM_DATE;
1156: end if;
1157:
1158: update XTR_ROLLOVER_TRANSACTIONS
1159: set DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate),
1160: DUAL_AUTHORISATION_BY = p_validated_by
1161: where DEAL_NUMBER = p_deal_no
1162: and START_DATE >= l_date

Line 1168: update XTR_ROLLOVER_TRANSACTIONS

1164:
1165: end if;
1166: -- add on 01 July 98
1167: elsif p_deal_type ='ONC' then
1168: update XTR_ROLLOVER_TRANSACTIONS
1169: set DUAL_AUTHORISATION_BY = p_validated_by,
1170: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1171: where DEAL_NUMBER = p_deal_no
1172: and TRANSACTION_NUMBER = p_trans_no