DBA Data[Home] [Help]

APPS.XTR_MISC_P dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 774: from XTR_ROLLOVER_TRANSACTIONS_V a,

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