APPS.FF_WRAPPER_SUP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 56

'-- Generated by Oracle FastFormula - do not delete.' || c_newline ||
'-- $Header: ffwrpsup.pkb 120.0 2005/05/27 23:26 appldev noship $' ||
c_newline;

Line: 402

select status
from   user_objects o
where  o.object_name = p_package_name
and    o.object_type = c_package_body
;

Line: 467

select o.status
,      o.object_type
from   user_objects o
where  o.object_name = p_package_name
;

Line: 476

select null
from   user_objects o
where  o.object_name = p_package_name
and    o.object_type = c_package_body
;

Line: 642

select status
from   user_objects o
where  o.object_name = p_package_name
and    o.object_type = c_package_body
;

Line: 666

select status
from   user_objects uo
where  uo.object_name = p_package_name
and    uo.object_type = c_package_body;

Line: 971

select ff.formula_id
,      ff.effective_start_date start_date
,      c_std_pkg_prefix || to_char(ff.formula_id) || '_' ||
       to_char(ff.effective_start_date, c_date_format) std_pkg_name
,      c_wrap_pkg_prefix || to_char(ff.formula_id) || '_' ||
       to_char(ff.effective_start_date, c_date_format) wrap_pkg_name
from   ff_formulas_f ff
,      ff_compiled_info_f fci
where  fci.formula_id = ff.formula_id
and    fci.effective_start_date = ff.effective_start_date
order  by 3
;

Line: 987

select null
from   user_objects uo
where  uo.object_name = p_package_name
and    uo.object_type = c_package
and    uo.status = c_object_valid
;

Line: 997

select uo.object_name
from   user_objects uo
where  uo.object_name like p_wrapper_name
and    uo.object_type = c_package
;

Line: 1266

select 'Y'
from   ff_compiled_info_f fci
where  fci.formula_id = p_formula_id
and    fci.effective_start_date = p_start_date
;

Line: 1315

select uo.object_name
from   user_objects uo
where  uo.object_name like p_prefix
and    uo.object_type = c_package
order  by uo.object_name;