APPS.PAY_CN_ELEMENT_TEMPLATE_PKG SQL Statements

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

Line: 36

   SELECT formula_id
   INTO   l_formula_id
   FROM   ff_formulas_f
   WHERE  legislation_code = 'CN'
   AND    formula_name = p_formula_name
   AND    p_effective_date  BETWEEN effective_start_Date AND effective_end_date;

Line: 297

     SELECT input_value_id
     INTO   l_input_value_id
     FROM   pay_input_values_f
     WHERE  p_effective_date BETWEEN effective_start_date
                             AND     effective_end_date
     AND    business_group_id = p_business_group_id
     AND    element_type_id   = p_element_type_id
     AND    NAME              = p_input_value_name;

Line: 308

     SELECT piv.input_value_id
          , pet.element_type_id
     INTO   l_input_value_id
          , l_element_type_id
     FROM   pay_input_values_f piv, pay_element_types_f pet
     WHERE  p_effective_date BETWEEN piv.effective_start_date
                             AND     piv.effective_end_date
     AND    p_effective_date BETWEEN pet.effective_start_date
                             AND     pet.effective_end_date
     AND    piv.legislation_code  = 'CN'
     AND    pet.legislation_code  = 'CN'
     AND    pet.element_name      = p_element_name
     AND    piv.NAME              = p_input_value_name
     AND    pet.element_type_id   = piv.element_type_id;

Line: 325

 SELECT pay_formula_result_rules_s.nextval
   INTO   v_form_res_rule_id
   FROM   sys.dual;

Line: 329

  INSERT INTO pay_formula_result_rules_f
   (formula_result_rule_id,
    effective_start_date,
    effective_end_date,
    business_group_id,
    status_processing_rule_id,
    result_name,
    result_rule_type,
    severity_level,
    input_value_id,
    last_update_date,
    last_updated_by,
    last_update_login,
    created_by,
    creation_date,
    element_type_id)
   VALUES
   (v_form_res_rule_id,
    p_effective_date,
    c_end_of_time,
    p_business_group_id,
    p_status_processing_rule_id,
    upper(p_result_name),
    p_result_rule_type,
    p_severity_level,
    l_input_value_id,
    trunc(sysdate),
    -1,
    -1,
    -1,
    trunc(sysdate),
    decode(p_result_rule_type,'I',l_element_type_id,null));

Line: 387

     SELECT template_name
     FROM   pay_element_templates
     WHERE  template_id = p_template_id;

Line: 394

    SELECT  pet.element_type_id
           ,pet.business_group_id
           ,pet.effective_start_date
           ,pet.object_version_number
    FROM    pay_element_types_f pet
           ,pay_element_templates tmp
    WHERE   pet.element_name  = tmp.base_name
    AND     tmp.template_id   = p_template_id;