DBA Data[Home] [Help]

APPS.XTR_FPS2_P dependencies on XTR_PORTFOLIOS

Line 266: from XTR_PORTFOLIOS

262: and b.CURRENCY = d.CURRENCY_CODE;
263: --
264: cursor PORT is
265: select PORTFOLIO
266: from XTR_PORTFOLIOS
267: where COMPANY_CODE = l_comp
268: and DEFAULT_PORTFOLIO = 'Y';
269: --
270: begin

Line 744: from xtr_portfolios pf

740: -- NOTE this brings back the portfolio name whereas the procedure below
741: -- brings back only the code
742: cursor PORT_DFLT is
743: select PORTFOLIO, NULL NAME
744: from xtr_portfolios pf
745: where COMPANY_CODE = l_company_code
746: and DEFAULT_PORTFOLIO = 'Y';
747: --
748: begin

Line 762: from XTR_PORTFOLIOS

758: l_portfolio_code IN OUT NOCOPY VARCHAR2) is
759: --
760: cursor PORT is
761: select PORTFOLIO
762: from XTR_PORTFOLIOS
763: where COMPANY_CODE = l_company_code
764: and DEFAULT_PORTFOLIO = 'Y';
765: --
766: begin