CONCURRENT ERROR
HI all
Will you please so kind and help me on this issue:'
ERROR:
ORACLE error 6550 in FDPSTP
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00201: identifier 'MTNVECO' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored .
PACKAGE:
CREATE OR REPLACE PROCEDURE APPS3_MTNAOL.MTN_VENDOR_COUNT
( p_from_date in date ,
p_to_date in date ,
errbuf OUT VARCHAR2,
retcode OUT NUMBER
) AS
P_ORG_ID NUMBER;
v_count number;
-- GET ALL Virtual Trade Customers --
CURSOR c1 IS
SELECT abc.vendor_name,abc.enabled_flag,assa.vendor_site_code,assa.inactive_date, count(*) "Number of Transactions"