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 611: from XTR_DEAL_DATE_AMOUNTS_V a

607: --
608: cursor get_ca is
609: 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,
610: 'FLOAT' FIXED_OR_FLOAT,nvl(a.amount,0) gross_amount,1 no_of_days
611: from XTR_DEAL_DATE_AMOUNTS_V a
612: where a.amount_date >=p_from_date
613: and a.company_code like p_company_code and a.currency like p_currency
614: and a.portfolio_code like p_portfolio_code
615: and a.status_code='CURRENT'

Line 652: from XTR_DEAL_DATE_AMOUNTS_V a,

648: 'IROFACEVAL',a.amount,
649: 'BDOFACEVAL',a.amount,
650: 'SWPTNFACEVAL',a.amount,
651: 'FRAFACEVAL',a.amount,0)),0) gross_amount
652: from XTR_DEAL_DATE_AMOUNTS_V a,
653: XTR_DEALS_V b
654: where a.amount_date >= p_from_date
655: and a.currency like p_currency
656: and a.company_code like p_company_code

Line 709: from XTR_DEAL_DATE_AMOUNTS_V a,

705: cursor get_fut is
706: select a.company_code,a.portfolio_code,a.deal_number,a.transaction_number,a.deal_type,
707: 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,
708: 'FIXED' FIXED_OR_FLOAT,nvl(a.amount,0) gross_amount,1 no_of_days
709: from XTR_DEAL_DATE_AMOUNTS_V a,
710: XTR_FUTURES b
711: where a.amount_date >=p_from_date
712: and a.company_code like p_company_code
713: and a.currency like p_currency

Line 1088: update XTR_DEAL_DATE_AMOUNTS

1084: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1085: where DEAL_NO = p_deal_no
1086: and DEAL_TYPE = p_deal_type;
1087:
1088: update XTR_DEAL_DATE_AMOUNTS
1089: set DUAL_AUTHORISATION_BY = p_validated_by,
1090: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1091: where DEAL_NUMBER = p_deal_no
1092: and TRANSACTION_NUMBER = p_trans_no

Line 1103: update XTR_DEAL_DATE_AMOUNTS

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

Line 1116: update XTR_DEAL_DATE_AMOUNTS

1112: set DUAL_AUTHORISATION_BY = p_validated_by,
1113: DUAL_AUTHORISATION_ON = decode(nvl(p_validated_by,'@@'),'@@',NULL,sysdate)
1114: where DEAL_NO = p_deal_no
1115: and DEAL_TYPE = p_deal_type;
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 DEAL_TYPE = p_deal_type;