APPS.PER_FASTFORMULA_EVENTS_UTILITY SQL Statements

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

Line: 26

      select paaf.effective_start_date,
             paaf.assignment_id
        from per_all_assignments_f paaf,
             per_assignment_status_types past
       where paaf.person_id = p_person_id
         and paaf.assignment_type = 'E'
          -- bug 2975652 only want to count active assignments
         and paaf.assignment_status_type_id = past.assignment_status_type_id
         and past.per_system_status = 'ACTIVE_ASSIGN'
         and paaf.effective_start_date
             between p_start_date
             and     p_end_date
             order by paaf.effective_start_date;

Line: 90

               ('person not found or no updates to assignment record between '||
                'dates ',18);

Line: 169

      select effective_start_date,
             assignment_id
        from per_all_assignments_f
       where person_id = p_person_id
         and assignment_type = 'E'
         and p_effective_date
             between effective_start_date
             and     effective_end_date
             order by effective_start_date;

Line: 311

      select paaf.effective_start_date,
             paaf.assignment_id
        from per_all_assignments_f paaf,
             per_assignment_status_types past
       where paaf.person_id = p_person_id
         and paaf.assignment_type = 'E'
          -- bug 2975652 only want to count active assignments
         and paaf.assignment_status_type_id = past.assignment_status_type_id
         and past.per_system_status = 'ACTIVE_ASSIGN'
         and paaf.effective_start_date
             between p_start_date
             and     p_end_date
             order by paaf.effective_start_date;

Line: 337

   p_date_tab.delete;

Line: 384

               ('person not found or no updates to assignment record between '||
                'dates ',18);

Line: 450

      select fff.formula_id
        from ff_formulas_f fff
             ,ff_formula_types fft
       where fff.formula_name = p_event_type
         and fff.formula_type_id = fft.formula_type_id
         and fft.formula_type_name = p_formula_type
         and fff.business_group_id = p_business_group_id
         and p_effective_date
             between fff.effective_start_date
             and     fff.effective_end_date;

Line: 462

      select fff.formula_id
        from ff_formulas_f fff
             ,ff_formula_types fft
       where fff.formula_name = 'PROMOTION_TEMPLATE'
         and fff.formula_type_id = fft.formula_type_id
         and fft.formula_type_name = p_formula_type
         and fff.business_group_id is null
         and p_effective_date
             between fff.effective_start_date
             and     fff.effective_end_date;