APPS.XTR_MISC_P dependencies on XTR_DEALS_V

Line 653: XTR_DEALS_V b

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

Line 762: XTR_DEALS_V b

758: 'RTMM',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
759: 'DEB',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
760: a.balance_out)),0) gross_amount
761: from XTR_ROLLOVER_TRANSACTIONS_V a,
762: XTR_DEALS_V b
763: where a.company_code like p_company_code and a.currency like p_currency
764: and a.status_code='CURRENT'
765: and a.portfolio_code like p_portfolio_code
766: and nvl(a.maturity_date,p_from_date+1) >p_from_date

Line 922: from xtr_deals_v a, xtr_deals_v b

918:
919: -- bug #1295341 jhung
920: cursor IRS_OTHER_DEAL is
921: select b.deal_no
922: from xtr_deals_v a, xtr_deals_v b
923: where a.int_swap_ref = b.int_swap_ref
924: and a.deal_type = b.deal_type
925: and a.deal_type = 'IRS'
926: and a.deal_subtype <> b.deal_subtype