DBA Data[Home] [Help]

APPS.XTR_MISC_P dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 761: from XTR_ROLLOVER_TRANSACTIONS_V a,

757: 'TMM',decode(nvl(a.balance_out,0),0,a.balance_out_bf,a.balance_out),
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