APPS.PER_QP_REPORTS SQL Statements

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

Line: 23

select formula_type_id
from   ff_formula_types
where   upper(formula_type_name) = 'QUICKPAINT';

Line: 45

select ff_qp_reports_s.nextval
from   sys.dual;

Line: 62

 select  'x'
 from    ff_qp_reports
 where   formula_type_id       = p_formula_type_id
 and     upper(qp_report_name) = upper(p_qp_report_name)
 and     nvl(business_group_id, nvl(p_business_group_id, 0)) =
                nvl(p_business_group_id, 0)
 and     nvl(legislation_code, nvl(p_legislation_code, ' ')) =
                nvl(p_legislation_code, ' ');