APPS.OPI_EDW_INV_DAILY_STAT_F_C dependencies on EDW_LOCAL_SYSTEM_PARAMETERS

Line 149: FROM EDW_LOCAL_SYSTEM_PARAMETERS;

145:
146: BEGIN
147: SELECT warehouse_currency_code, rate_type
148: INTO l_global_currency_code, l_rate_type
149: FROM EDW_LOCAL_SYSTEM_PARAMETERS;
150: EXCEPTION
151: WHEN OTHERS THEN
152: RAISE currency_not_exist;
153: END;

Line 519: Errbuf:= 'No or too many rows existed in EDW_LOCAL_SYSTEM_PARAMETERS table';

515: --dbms_output.put_line('currency_conv_rate_not_exist ' || l_exception_msg);
516: --raise;
517:
518: WHEN currency_not_exist THEN
519: Errbuf:= 'No or too many rows existed in EDW_LOCAL_SYSTEM_PARAMETERS table';
520:
521: Retcode:=sqlcode;
522: l_exception_msg := Retcode || ':' || Errbuf;
523: rollback;