APPS.PQP_GB_SS_ABSENCE_TEMPLATE SQL Statements

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

Line: 15

select lookup_code abs_type_id,meaning abs_type_name
from fnd_lookup_values_vl
where lookup_type = P_LOOKUP_TYPE
  and enabled_flag = 'Y'
  and P_EFFECTIVE_START_DATE BETWEEN
      nvl(start_date_active,P_EFFECTIVE_START_DATE)
  AND nvl(end_date_active,P_EFFECTIVE_START_DATE);

Line: 43

SELECT
fra.formula_id,
fra.formula_name,
fty.formula_type_id,
fty.formula_type_name
FROM
ff_formulas_f fra,
ff_formula_types fty,
pay_status_processing_rules_f spr
WHERE fty.formula_type_id = fra.formula_type_id
  AND fra.formula_id = spr.formula_id
  AND spr.assignment_status_type_id IS NULL
  AND spr.element_type_id = p_element_type_id;

Line: 62

SELECT
fra.formula_id,
fra.formula_name,
fty.formula_type_id,
fty.formula_type_name
FROM
ff_formulas_f fra,
ff_formula_types fty
WHERE fty.formula_type_id = fra.formula_type_id
  AND fra.formula_id = p_formula_id;

Line: 178

select
security_group_id
from per_business_groups
where business_group_id = P_BUSINESS_GROUP_ID;

Line: 448

l_select               VARCHAR2(100);

Line: 709

l_select               VARCHAR2(100);