DBA Data[Home] [Help]

APPS.AZW_UTIL dependencies on AZ_CONTEXTS_SQL

Line 306: sqlstatement az_contexts_sql.SQL_STATEMENT%TYPE;

302: current_ctx_id OUT NOCOPY NUMBER) IS
303:
304: curs integer;
305: rows integer;
306: sqlstatement az_contexts_sql.SQL_STATEMENT%TYPE;
307: opm_id varchar2(30);
308:
309: BEGIN
310:

Line 319: FROM az_contexts_sql

315: --where orgn_code = opm_id;
316:
317: SELECT sql_statement
318: INTO sqlstatement
319: FROM az_contexts_sql
320: WHERE context = ctx_type
321: AND purpose = 'VALIDATE';
322:
323: curs := DBMS_SQL.OPEN_CURSOR;