APPS.PAY_NO_TAX_TABLE_UPLOAD SQL Statements

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

Line: 33

select LEGISLATION_CODE from  PER_BUSINESS_GROUPS where BUSINESS_GROUP_ID=p_business_group;

Line: 104

select LEGISLATION_CODE from PER_BUSINESS_GROUPS where BUSINESS_GROUP_ID=p_business_group;

Line: 111

    select RANGE_TABLE_ID ,OBJECT_VERSION_NUMBER
    from   PAY_RANGE_TABLES_F
    where  LEGISLATION_CODE        = p_Legislation_Code
    AND    BUSINESS_GROUP_ID       = p_business_group
    AND    EFFECTIVE_START_DATE   >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
    AND    EFFECTIVE_END_DATE     <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');

Line: 125

    select RANGE_TABLE_ID ,OBJECT_VERSION_NUMBER
    from   PAY_RANGE_TABLES_F
    where  LEGISLATION_CODE        = p_Legislation_Code
    AND    EFFECTIVE_START_DATE   >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
    AND    EFFECTIVE_END_DATE     <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');

Line: 134

SELECT RANGE_ID, OBJECT_VERSION_NUMBER
from   PAY_RANGES_F
where  RANGE_TABLE_ID =p_RANGE_TABLE_ID
AND    EFFECTIVE_START_DATE    >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
AND    EFFECTIVE_END_DATE      <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');

Line: 161

    DELETE  FROM  PAY_RANGE_TEMP;

Line: 182

        pay_range_api.delete_range(l_RANGE_ID,l_Ran_OBJECT_VERSION_NUMBER);

Line: 186

pay_range_table_api.delete_range_table(l_RANGE_TABLE_ID,l_Prf_OBJECT_VERSION_NUMBER);

Line: 195

/*        DELETE FROM PAY_RANGES_F
        where RANGE_TABLE_ID in
                           ( select RANGE_TABLE_ID
                             from   PAY_RANGE_TABLES_F
                             where  LEGISLATION_CODE        = Legislation_Code
                             AND    BUSINESS_GROUP_ID       = p_business_group
                             AND    EFFECTIVE_START_DATE   >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
                             AND    EFFECTIVE_END_DATE     <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS')
                            )
        AND  EFFECTIVE_START_DATE    >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
        AND  EFFECTIVE_END_DATE      <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');

Line: 208

        DELETE  FROM  PAY_RANGE_TABLES_F
        WHERE   LEGISLATION_CODE     = Legislation_Code
        AND  BUSINESS_GROUP_ID       = p_business_group
        AND  EFFECTIVE_START_DATE    >= TO_DATE(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
        AND  EFFECTIVE_END_DATE      <= TO_DATE(p_effective_end_date,'YYYY/MM/DD HH24:MI:SS');

Line: 284

       SELECT   'Y'
    FROM    PAY_RANGE_TABLES_F
    WHERE   LEGISLATION_CODE     = p_legislation_code
        AND BUSINESS_GROUP_ID    = p_business_group
    AND EFFECTIVE_START_DATE = p_effective_start_date;

Line: 297

       SELECT   'Y'
    FROM    PAY_RANGE_TABLES_F
    WHERE   LEGISLATION_CODE     = p_legislation_code
    AND BUSINESS_GROUP_ID    IS NULL
    AND EFFECTIVE_START_DATE = p_effective_start_date;

Line: 307

       SELECT   'Y'
    FROM    PAY_RANGE_TABLES_F
    WHERE   LEGISLATION_CODE     = p_legislation_code
        AND BUSINESS_GROUP_ID    = p_business_group
    AND p_effective_start_date BETWEEN
                           EFFECTIVE_START_DATE
                       AND EFFECTIVE_END_DATE
    AND  EFFECTIVE_END_DATE <> c_end_of_time;

Line: 322

       SELECT   'Y'
    FROM    PAY_RANGE_TABLES_F
    WHERE   LEGISLATION_CODE     = p_legislation_code
    AND BUSINESS_GROUP_ID    IS NULL
    AND p_effective_start_date BETWEEN
                           EFFECTIVE_START_DATE
                       AND EFFECTIVE_END_DATE
    AND  EFFECTIVE_END_DATE <> c_end_of_time;

Line: 338

       SELECT   RANGE_TABLE_ID,object_version_number
    FROM    PAY_RANGE_TABLES_F
    WHERE   LEGISLATION_CODE     = p_legislation_code
        AND BUSINESS_GROUP_ID    = p_business_group
    AND EFFECTIVE_START_DATE < p_effective_start_date
        AND     RANGE_TABLE_NUMBER = l_RANGE_TABLE_NUMBER
        AND EARNINGS_TYPE    =l_earnings_type
        AND PERIOD_FREQUENCY = l_PERIOD_FREQUENCY
        AND     EFFECTIVE_END_DATE = c_end_of_time;

Line: 357

       SELECT   RANGE_TABLE_ID,object_version_number
    FROM    PAY_RANGE_TABLES_F
    WHERE   LEGISLATION_CODE     = p_legislation_code
    AND BUSINESS_GROUP_ID    IS NULL
    AND EFFECTIVE_START_DATE < p_effective_start_date
        AND     RANGE_TABLE_NUMBER = l_RANGE_TABLE_NUMBER
        AND EARNINGS_TYPE    =l_earnings_type
        AND PERIOD_FREQUENCY = l_PERIOD_FREQUENCY
        AND     EFFECTIVE_END_DATE = c_end_of_time;

Line: 370

       SELECT   RANGE_ID
    FROM    PAY_RANGES_F
    WHERE   RANGE_TABLE_ID = l_RANGE_TABLE_ID
        AND EFFECTIVE_START_DATE < p_effective_start_date
        AND     EFFECTIVE_END_DATE <> c_end_of_time;

Line: 379

       SELECT distinct
        RANGE_TABLE_NUMBER,
        PERIOD_FREQUENCY,
        EARNINGS_TYPE
       FROM PAY_RANGE_TEMP;

Line: 388

      SELECT    RANGE_ID,LOW_BAND,
        HIGH_BAND,
        AMOUNT1
      FROM  PAY_RANGE_TEMP
      WHERE RANGE_TABLE_NUMBER  = l_range_table_num
      AND   PERIOD_FREQUENCY    = l_period_frequency
      AND   EARNINGS_TYPE       = l_earnings_type;

Line: 399

       SELECT   RANGE_TABLE_ID,
        RANGE_TABLE_NUMBER,
        PERIOD_FREQUENCY,
        EARNINGS_TYPE
    FROM    PAY_RANGE_TABLES_F
    WHERE   LEGISLATION_CODE     = p_legislation_code
        AND BUSINESS_GROUP_ID    = p_business_group
    AND EFFECTIVE_START_DATE = p_effective_start_date
    AND EFFECTIVE_END_DATE   = c_end_of_time;

Line: 415

       SELECT   RANGE_TABLE_ID,
        RANGE_TABLE_NUMBER,
        PERIOD_FREQUENCY,
        EARNINGS_TYPE
    FROM    PAY_RANGE_TABLES_F
    WHERE   LEGISLATION_CODE     = p_legislation_code
    AND BUSINESS_GROUP_ID    IS NULL
    AND EFFECTIVE_START_DATE = p_effective_start_date
    AND EFFECTIVE_END_DATE   = c_end_of_time;

Line: 433

select max(range_id) into l_max_range_id  from PAY_RANGE_TEMP;

Line: 483

               pay_range_table_api.update_range_table
                 (
              p_RANGE_TABLE_ID                          => l_csr_range_table_id
                 ,p_EFFECTIVE_END_DATE                      => p_effective_start_date -1
                 ,p_OBJECT_VERSION_NUMBER                   => l_dummy
                 );

Line: 563

         select decode(low_band-1,-1,99999,low_band-1) into l_high_band from PAY_RANGE_TEMP where range_id=l_range_id+1;

Line: 640

       SELECT   RANGE_ID,object_version_number
    FROM    PAY_RANGES_F
    WHERE   RANGE_TABLE_ID = p_RANGE_TABLE_ID
        AND EFFECTIVE_START_DATE < p_effective_start_date
        AND     EFFECTIVE_END_DATE = c_end_of_time;

Line: 655

        Pay_range_api.Update_range
           (
               P_RANGE_TABLE_ID                          => p_RANGE_TABLE_ID
                      ,P_EFFECTIVE_END_DATE              => p_effective_start_date - 1
              ,P_OBJECT_VERSION_NUMBER                   => l_object_version_number
              ,P_RANGE_ID                                => l_Range_id
            );

Line: 773

                     insert into
                     pay_range_temp
                     ( RANGE_ID,
                       RANGE_TABLE_NUMBER,
                       ROW_VALUE_UOM,
                       PERIOD_FREQUENCY,
                       EARNINGS_TYPE,
                       LOW_BAND,
                       HIGH_BAND,
                       AMOUNT1,
                       AMOUNT2)
                      values
                     (
                      pay_ranges_f_s.nextval,
                      l_RANGE_TABLE_NUMBER,
                      NULL,
                      l_PERIOD_FREQUENCY,
                      l_EARNINGS_TYPE,
                      l_LOW_BAND,
                      NULL,
                      l_AMOUNT1,
                      NULL);