APPS.XTR_EXP_SUMM_P dependencies on XTR_DEALS_V

Line 965: XTR_DEALS_V b

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
969: and (nvl(b.start_date,l_date) <= l_date or a.deal_type='FXO')