APPS.XTR_MISC_P dependencies on XTR_DEALS_V

Line 666: XTR_DEALS_V b

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
670: and a.portfolio_code like p_portfolio_code

Line 775: XTR_DEALS_V b

771: 'RTMM',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
772: 'DEB',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
773: a.balance_out)),0) gross_amount
774: from XTR_ROLLOVER_TRANSACTIONS_V a,
775: XTR_DEALS_V b
776: where a.company_code like p_company_code and a.currency like p_currency
777: and a.status_code='CURRENT'
778: and a.portfolio_code like p_portfolio_code
779: and nvl(a.maturity_date,p_from_date+1) >p_from_date

Line 935: from xtr_deals_v a, xtr_deals_v b

931:
932: -- bug #1295341 jhung
933: cursor IRS_OTHER_DEAL is
934: select b.deal_no
935: from xtr_deals_v a, xtr_deals_v b
936: where a.int_swap_ref = b.int_swap_ref
937: and a.deal_type = b.deal_type
938: and a.deal_type = 'IRS'
939: and a.deal_subtype <> b.deal_subtype