eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_LIMITS_P dependencies on XTR_COUNTRY_COMPANY_LIMITS

Line 1304: FROM xtr_country_company_limits

1300: p_err_code OUT NOCOPY VARCHAR2) is
1301: --
1302: cursor c_get_util (pc1_company_code VARCHAR2,pc1_country_code VARCHAR2) is
1303: SELECT nvl(limit_amount,0), nvl(utilised_amount,0)
1304: FROM xtr_country_company_limits
1305: WHERE company_code = pc1_company_code
1306: AND country_code = pc1_country_code
1307: AND (limit_amount <> 0 OR utilised_amount <> 0);
1308: --

Line 1832: update xtr_COUNTRY_COMPANY_LIMITS_V

1828: update xtr_COUNTERPARTY_LIMITS_V
1829: set UTILISED_AMOUNT = 0;
1830: update xtr_MASTER_CURRENCIES_V
1831: set UTILISED_AMOUNT = 0;
1832: update xtr_COUNTRY_COMPANY_LIMITS_V
1833: set UTILISED_AMOUNT = 0;
1834: update xtr_GROUP_LIMITS_V
1835: set UTILISED_AMOUNT = 0;
1836: --