APPS.XTR_EXP_SUMM_P dependencies on XTR_MIRROR_DDA_LIMIT_ROW_V

Line 947: from XTR_MIRROR_DDA_LIMIT_ROW_V

943: sum(nvl(amount_indic,1)*nvl(amount,0)) gross_principal,
944: sum(nvl(amount_indic,1)*nvl(amount,0)*nvl(transaction_rate,0)
945: /(decode(deal_type,'FX',1,'FXO',1,100))) weighted_amt,
946: count(distinct decode(deal_type,'ONC',transaction_number,deal_number)) no_of_deals
947: from XTR_MIRROR_DDA_LIMIT_ROW_V
948: where (amount_date >= l_date or deal_type = 'ONC' or deal_type = 'CMF')
949: and deal_type <>'CA'
950: group by company_code,deal_type,currency,contra_ccy,currency_combination,
951: decode(deal_type,'FX','%',deal_subtype),limit_party,product_type,portfolio_code;

Line 964: from XTR_MIRROR_DDA_LIMIT_ROW_V a,

960: round(sum(nvl(a.amount_indic,1)*nvl(a.amount,0)),0) gross_principal,
961: round(sum(nvl(a.amount_indic,1)*nvl(a.amount,0)*nvl(a.transaction_rate,0)
962: /(decode(a.deal_type,'FX',1,'FXO',1,100))),0) weighted_amt,
963: count(distinct a.deal_number) no_of_deals
964: from XTR_MIRROR_DDA_LIMIT_ROW_V a,
965: XTR_DEALS_V b
966: where a.amount_date > l_date
967: and a.deal_type not in('CA','ONC','CMF','IG')
968: and a.deal_number=b.deal_no

Line 981: from XTR_MIRROR_DDA_LIMIT_ROW_V a,

977: a.portfolio_code,
978: round(sum(nvl(a.amount_indic,1)*nvl(a.amount,0)),0) gross_principal,
979: round(sum(nvl(a.amount_indic,1)*nvl(a.amount,0)*nvl(a.transaction_rate,0)/100),0) weighted_amt,
980: count(distinct decode(a.deal_type,'ONC',a.transaction_number,a.deal_number)) no_of_deals
981: from XTR_MIRROR_DDA_LIMIT_ROW_V a,
982: XTR_ROLLOVER_TRANSACTIONS_V b
983: where a.deal_type in('ONC','CMF','IG')
984: and a.deal_number=b.deal_number
985: and a.transaction_number=b.transaction_number

Line 1012: from XTR_mirror_dda_limit_row_V

1008: l_dummy number;
1009: --
1010: cursor get_tmm_row is
1011: select rowid,deal_number
1012: from XTR_mirror_dda_limit_row_V
1013: where amount_date > l_date
1014: and deal_type = 'TMM';
1015: --
1016: l_deal_no number;

Line 1034: from XTR_mirror_dda_limit_row_V

1030: cursor get_ca_row is
1031: select COMPANY_CODE,CURRENCY,DEAL_TYPE,AMOUNT_DATE,TRANSACTION_RATE,
1032: CONTRA_CCY,CURRENCY_COMBINATION,DEAL_SUBTYPE,
1033: AMOUNT,HCE_AMOUNT,LIMIT_PARTY,PORTFOLIO_CODE,PRODUCT_TYPE,ACCOUNT_NO
1034: from XTR_mirror_dda_limit_row_V
1035: where deal_type='CA';
1036:
1037: --
1038: bal get_ca_row%ROWTYPE;