APPS.PQP_CANDM_UPG SQL Statements

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

Line: 40

 SELECT formula_name,formula_text
  FROM  pay_shadow_formulas
 where  template_type='T'
   AND  formula_name
    IN  ( '_MILEAGE_CLAIM_PVT'
         );

Line: 52

 SELECT fff.formula_id
       ,fff.effective_start_date
       ,fff.effective_end_date
       ,fff.formula_type_id
       ,fff.formula_name
       ,fff.business_group_id
       ,fff.description
       ,fff.sticky_flag
       ,fff.compile_flag
       ,paf.status_processing_rule_id status_processing_rule_id
  FROM ff_formulas_f fff
       ,PAY_STATUS_PROCESSING_RULES_F  paf
       --,pay_element_types_f petf
  WHERE (formula_name
   LIKE NVL(p_formula_name,'%_MILEAGE_CLAIM_PVT')
  )
  AND fff.formula_id=paf.formula_id
  AND paf.assignment_status_type_id IS NULL
  AND fff.business_group_id=paf.business_group_id
    ORDER BY fff.formula_id,fff.effective_start_date ;

Line: 77

 SELECT fff.formula_id
       ,fff.effective_start_date
       ,fff.effective_end_date
       ,fff.formula_type_id
       ,fff.formula_name
       ,substr(fff.formula_name,0,(length(fff.formula_name)-12)) fname
       ,fff.business_group_id
       ,paf.status_processing_rule_id
  FROM ff_formulas_f fff
       ,PAY_STATUS_PROCESSING_RULES_F  paf
  WHERE formula_name=cp_formula_name
  AND fff.business_group_id=cp_business_group_id
  AND fff.business_group_id=paf.business_group_id
  AND fff.formula_id=paf.formula_id
  AND paf.assignment_status_type_id IS NULL
    ORDER BY fff.formula_id,fff.effective_start_date ;

Line: 100

  SELECT element_name
   FROM pay_element_types_f petf
  WHERE element_type_id = (SELECT distinct(pspr.element_type_id)
                             FROM pay_status_processing_rules_f pspr
                                 ,pay_element_type_extra_info pete
                            WHERE pspr.formula_id =cformula_id
                              AND pspr.business_group_id=cbusiness_group_id
                              AND pspr.business_group_id=petf.business_group_id
                              AND pspr.element_type_id=pete.element_type_id
                              AND pete.INFORMATION_TYPE =
                                       'PQP_VEHICLE_MILEAGE_INFO'
                              AND pete.EEI_INFORMATION1 in ('P','PP',
                                                             'PM'
                                                            ));

Line: 129

  SELECT TO_CHAR(SYSDATE,'YYYY')
    INTO l_dt
    FROM DUAL;

Line: 160

     'SELECT formula_text FROM ff_formulas_f WHERE formula_name= :x AND sysdate BETWEEN
      effective_start_date and effective_end_date';

Line: 199

      UPDATE ff_formulas_f
        SET formula_name = l_formula_name||l_dt||'BAK'
        WHERE formula_name = l_formula_name
          AND sysdate between effective_start_date and effective_end_date;

Line: 205

       UPDATE ff_formulas_f_tl
        SET formula_name = l_formula_name||l_dt||'BAK'
        WHERE formula_name = l_formula_name;

Line: 209

         INSERT INTO ff_formulas_f(
                                 FORMULA_ID
                                 ,EFFECTIVE_START_DATE
                                 ,EFFECTIVE_END_DATE
                                 ,BUSINESS_GROUP_ID
                                 ,LEGISLATION_CODE
                                 ,FORMULA_TYPE_ID
                                 ,FORMULA_NAME
                                 ,DESCRIPTION
                                 ,FORMULA_TEXT
                                 ,STICKY_FLAG
                                 ,COMPILE_FLAG
                                 ,LAST_UPDATE_DATE
                                 ,LAST_UPDATED_BY
                                 ,LAST_UPDATE_LOGIN
                                 ,CREATED_BY
                                 ,CREATION_DATE )

                          VALUES(
                                  ff_formulas_s.nextval
                                  ,l_formula.EFFECTIVE_START_DATE
                                  ,l_formula.EFFECTIVE_end_DATE
                                  ,l_formula.business_group_id
                                  ,NULL
                                  ,l_formula.formula_type_id
                                  ,l_formula.formula_name
                                  ,l_formula.description
                                  ,l_temp_text  --l_formula.formula_text
                                  ,l_formula.sticky_flag
                                  ,l_formula.compile_flag
                                  ,sysdate
                                  ,1
                                  ,1
                                  ,1
                                  ,sysdate
                                );

Line: 246

       /* INSERT INTO ff_formulas_f_tl (
                                  FORMULA_ID
                                 ,LANGUAGE
                                 ,SOURCE_LANG
                                 ,FORMULA_NAME
                                 ,DESCRIPTION
                                 ,LAST_UPDATE_DATE
                                 ,LAST_UPDATED_BY
                                 ,LAST_UPDATE_LOGIN
                                 ,CREATED_BY
                                 ,CREATION_DATE )
                          VALUES
                                 (ff_formulas_s.currval
                                 ,'US'
                                 ,'US'
                                 ,l_formula.formula_name
                                 ,l_formula.description
                                 ,sysdate
                                 ,1
                                 ,1
                                 ,1
                                 ,sysdate
                                );*/

Line: 270

       UPDATE pay_status_processing_rules_f
          SET formula_id=ff_formulas_s.currval
        WHERE status_processing_rule_id=l_formula.status_processing_rule_id
          AND sysdate BETWEEN effective_start_date and effective_end_date;