APPS.PQP_SCHEDULE_CALCULATION_PKG SQL Statements

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

Line: 242

  SELECT COUNT(pur.row_low_range_or_name)
  FROM   pay_user_rows_f pur
  WHERE  pur.user_row_id IN
          (SELECT DISTINCT uci.user_row_id
           FROM   pay_user_tables put,
                  pay_user_columns puc,
                  pay_user_column_instances_f uci
           WHERE put.user_table_name  = g_udt_name
             AND put.legislation_code = g_legislation_code -- Added on 02/01/2003
             AND puc.user_table_id    = put.user_table_id
             AND puc.user_column_name = p_wp_dets.work_pattern
             AND (
                   puc.business_group_id = p_wp_dets.business_group_id
                 OR
                  (puc.business_group_id IS NULL
                    AND puc.legislation_code = g_legislation_code)
               --OR global
                 -- CANNOT BE as the table itself is legislatively seeded.
                 )
             AND uci.user_column_id   = puc.user_column_id
             AND (
                   uci.business_group_id = p_wp_dets.business_group_id
                  OR
                   (uci.business_group_id IS NULL
                    AND uci.legislation_code = g_legislation_code)
                 --OR global
                   -- CANNOT BE as the work pattern itself is either
                   -- legislative or business group specific
                 )
             AND (p_calc_stdt BETWEEN uci.effective_start_date
                                  AND uci.effective_end_date
                  OR
                  p_calc_edt BETWEEN uci.effective_start_date
                                 AND uci.effective_end_date)

          )    AND pur.row_low_range_or_name like
           'Day __';

Line: 1546

  select work_pattern
  from   pqp_assignment_attributes_f paa
  where  assignment_id = p_assignment_id
    and  business_group_id = p_business_group_id
    and  p_effective_date between paa.effective_start_date
                              and paa.effective_end_date ;

Line: 1602

	 -- calculate the same and update the udt and refetch the value.
         IF l_value IS NULL THEN

	    l_proc_step := 35 ;

Line: 1611

	    pqp_update_work_pattern_table.update_working_days_in_week
             (errbuf                => l_errbuff
             ,retcode               => l_retcode
             ,p_column_name         => l_work_pattern
             ,p_business_group_id   => p_business_group_id
             ,p_overwrite_if_exists => 'Y'
             );

Line: 1806

  SELECT ucs.user_column_id
  FROM   pay_user_tables    uts
        ,pay_user_columns   ucs
  WHERE  uts.user_table_name = p_user_table_name -- PQP_COMPANY_WORK_PATTERNS
    AND  uts.business_group_id IS NULL
    AND  uts.legislation_code = p_legislation_code -- as one table is seeded per legislation
    AND  ucs.user_table_id   = uts.user_table_id -- only work patterns that belong to the above table
    AND  ucs.user_column_name = p_user_column_name -- which match this name work_pattern_name
    AND  ( ucs.business_group_id = p_business_group_id -- in the users bg
          OR
           (ucs.business_group_id IS NULL  -- or seeded
            AND
            ucs.legislation_code = p_legislation_code -- for the users legislation code
           )
         );

Line: 1832

  SELECT  uci.user_row_id
         ,uci.value hours_in_text
         ,uci.effective_start_date
         ,uci.effective_end_date
  FROM    pay_user_column_instances_f uci
  WHERE   uci.user_column_id = p_user_column_id -- represents the work pattern
    AND   p_effective_date
            BETWEEN uci.effective_start_date
                AND uci.effective_end_date
    AND   ( uci.business_group_id = p_business_group_id
           OR
            ( uci.business_group_id IS NULL
             AND
              uci.legislation_code = p_legislation_code
            )
          );

Line: 1854

  SELECT  urw.row_low_range_or_name day_name
  FROM    pay_user_rows_f  urw
  WHERE   urw.user_row_id = p_user_row_id
    AND   p_effective_date
            BETWEEN urw.effective_start_date
                AND urw.effective_end_date
    AND   urw.row_low_range_or_name like
           'Day __';