APPS.XTR_MISC_P dependencies on XTR_DEAL_DATE_AMOUNTS

Line 394: from xtr_deal_date_amounts

390:
391: -- bug 3800146 IAC -Redesign Project Added lines
392: cursor iac_validated is
393: select dual_authorisation_by, dual_authorisation_on
394: from xtr_deal_date_amounts
395: where transaction_number=p_transaction_number
396: and deal_number = 0 -- bug 4957910
397: and dual_authorisation_by is not null
398: and deal_type='IAC';

Line 624: from XTR_DEAL_DATE_AMOUNTS_V a

620: --
621: cursor get_ca is
622: select a.company_code,a.portfolio_code,a.deal_number,a.transaction_number,a.deal_type,a.deal_subtype,a.currency,a.transaction_rate,a.amount_date start_date,a.amount_date maturity_date,p_to_date to_date,p_from_date from_date,
623: 'FLOAT' FIXED_OR_FLOAT,nvl(a.amount,0) gross_amount,1 no_of_days
624: from XTR_DEAL_DATE_AMOUNTS_V a
625: where a.amount_date >=p_from_date
626: and a.company_code like p_company_code and a.currency like p_currency
627: and a.portfolio_code like p_portfolio_code
628: and a.status_code='CURRENT'

Line 665: from XTR_DEAL_DATE_AMOUNTS_V a,

661: 'IROFACEVAL',a.amount,
662: 'BDOFACEVAL',a.amount,
663: 'SWPTNFACEVAL',a.amount,
664: 'FRAFACEVAL',a.amount,0)),0) gross_amount
665: from XTR_DEAL_DATE_AMOUNTS_V a,
666: XTR_DEALS_V b
667: where a.amount_date >= p_from_date
668: and a.currency like p_currency
669: and a.company_code like p_company_code

Line 722: from XTR_DEAL_DATE_AMOUNTS_V a,

718: cursor get_fut is
719: select a.company_code,a.portfolio_code,a.deal_number,a.transaction_number,a.deal_type,
720: a.deal_subtype,a.currency,a.transaction_rate,a.amount_date start_date,a.amount_date maturity_date,p_to_date to_date,p_from_date from_date,
721: 'FIXED' FIXED_OR_FLOAT,nvl(a.amount,0) gross_amount,1 no_of_days
722: from XTR_DEAL_DATE_AMOUNTS_V a,
723: XTR_FUTURES b
724: where a.amount_date >=p_from_date
725: and a.company_code like p_company_code
726: and a.currency like p_currency

Line 1101: update XTR_DEAL_DATE_AMOUNTS

1097: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1098: where DEAL_NO = p_deal_no
1099: and DEAL_TYPE = p_deal_type;
1100:
1101: update XTR_DEAL_DATE_AMOUNTS
1102: set DUAL_AUTHORISATION_BY = p_validated_by,
1103: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1104: where DEAL_NUMBER = p_deal_no
1105: and TRANSACTION_NUMBER = p_trans_no

Line 1116: update XTR_DEAL_DATE_AMOUNTS

1112: where DEAL_NUMBER = p_deal_no
1113: and TRANSACTION_NUMBER = p_trans_no
1114: and DEAL_TYPE = p_deal_type;
1115:
1116: update XTR_DEAL_DATE_AMOUNTS
1117: set DUAL_AUTHORISATION_BY = p_validated_by,
1118: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1119: where DEAL_NUMBER = p_deal_no
1120: and TRANSACTION_NUMBER = p_trans_no

Line 1129: update XTR_DEAL_DATE_AMOUNTS

1125: set DUAL_AUTHORISATION_BY = p_validated_by,
1126: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1127: where DEAL_NO = p_deal_no
1128: and DEAL_TYPE = p_deal_type;
1129: update XTR_DEAL_DATE_AMOUNTS
1130: set DUAL_AUTHORISATION_BY = p_validated_by,
1131: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1132: where DEAL_NUMBER = p_deal_no
1133: and DEAL_TYPE = p_deal_type;