APPS.PAY_ZA_TAX_YEAR_START_PKG SQL Statements

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

Line: 22

REM A.STANDER      12-MAR-2000 110.2           Change not to update people that
REM                                            have been updated manualy
REM L. Kloppers    23-SEP-2002 115.1   2224332 Modify to cater for new
REM                                            Tax Statuses 'N' and 'P'
REM ========================================================================
*/


/* This procedure sets the Tax Certificate number
   (input value on the ZA_Tax element) to 'N', clears the
   Tax Directive Number and Tax Directive Value (also input
   values on the ZA_Tax element) and set the input value
   Tax Status on the ZA_Tax element to 'A' - Normal where the Tax Status is
   'C' or 'D', and set it to 'M' - Private Director where the Tax Status is
   'N' or 'P'*/

PROCEDURE reset_all_ind
          (
           p_errmsg        OUT NOCOPY VARCHAR2,
           p_errcode       OUT NOCOPY NUMBER,
           p_payroll           NUMBER,
           p_tax_year          VARCHAR2)
AS
    l_tax_year              NUMBER;

Line: 63

    l_tax_year_start := Pay_Za_Update_Pkg.get_tax_year_end(p_payroll, p_tax_year);

Line: 71

      SELECT element_type_id
        INTO l_element_type_id
        FROM pay_element_types_f
       WHERE element_name = 'ZA_Tax'
         AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;

Line: 79

      SELECT input_value_id
        INTO tax_status_id
        FROM pay_input_values_f
       WHERE element_type_id = l_element_type_id
         AND name = 'Tax Status'
         AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;

Line: 86

      SELECT input_value_id
        INTO tax_directive_number_id
        FROM pay_input_values_f
       WHERE element_type_id = l_element_type_id
         AND name = 'Tax Directive Number'
         AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;

Line: 93

       SELECT input_value_id
         INTO tax_directive_value_id
         FROM pay_input_values_f
        WHERE element_type_id = l_element_type_id
          AND name = 'Tax Directive Value'
          AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;

Line: 102

    IF Pay_Za_Update_Pkg.payroll_updateble(p_payroll, l_tax_year) THEN

       FOR v_assignments IN c_assignments(p_payroll, l_tax_year_end)
 LOOP

      OPEN c_entry_details(l_element_type_id,tax_status_id,v_assignments.assignment_id,p_payroll,l_tax_year_end);

Line: 112

           IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
              l_new_value := 'Normal';

Line: 115

                  Pay_Za_Update_Pkg.update_this_record
                                (
                                 l_one_record,
                                 l_new_value,
                                 'UPDATE_CHANGE_INSERT'
                                 );

Line: 127

           IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
              l_new_value := 'Private Director';

Line: 130

                  Pay_Za_Update_Pkg.update_this_record
                                (
                                 l_one_record,
                                 l_new_value,
                                 'UPDATE_CHANGE_INSERT'
                                 );

Line: 147

         IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
            l_new_value := ' ';

Line: 150

                  Pay_Za_Update_Pkg.update_this_record
                                (
                                 l_one_record,
                                 l_new_value,
                                 'UPDATE_CHANGE_INSERT'
                                 );

Line: 166

        IF NOT Pay_Za_Update_Pkg.entry_valid(l_one_record,'NEXT_DAY_CHANGE') THEN
--           l_new_value := ' ';

Line: 170

                  Pay_Za_Update_Pkg.update_this_record
                                (
                                 l_one_record,
                                 l_new_value,
                                 'UPDATE_CHANGE_INSERT'
                                 );

Line: 183

           Pay_Za_Update_Pkg.update_tysp_table
                         (
                          p_payroll,
                          l_tax_year
                         );

Line: 217

    l_tax_year_start := Pay_Za_Update_Pkg.get_tax_year_end(p_payroll, p_tax_year);

Line: 224

      SELECT element_type_id
        INTO l_element_type_id
        FROM pay_element_types_f
       WHERE element_name = 'ZA_Tax'
         AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;

Line: 231

      SELECT input_value_id
        INTO tax_status_id
        FROM pay_input_values_f
       WHERE element_type_id = l_element_type_id
         AND name = 'Tax Status'
         AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;

Line: 238

      SELECT input_value_id
        INTO tax_directive_number_id
        FROM pay_input_values_f
       WHERE element_type_id = l_element_type_id
         AND name = 'Tax Directive Number'
         AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;

Line: 245

       SELECT input_value_id
         INTO tax_directive_value_id
         FROM pay_input_values_f
        WHERE element_type_id = l_element_type_id
          AND name = 'Tax Directive Value'
          AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;

Line: 253

    IF Pay_Za_Update_Pkg.payroll_rollbackable(p_payroll, l_tax_year) THEN

      FOR v_assignments IN c_assignments(p_payroll, l_tax_year_end)
 LOOP

-- Check and update tax_status if tax_status in ('C','D','N','P') --
  OPEN c_entry_details(l_element_type_id,tax_status_id,v_assignments.assignment_id,p_payroll,l_tax_year_end);

Line: 262

           Pay_Za_Update_Pkg.rollback_this_record(l_one_record);

Line: 268

       Pay_Za_Update_Pkg.rollback_this_record(l_one_record);

Line: 274

           Pay_Za_Update_Pkg.rollback_this_record(l_one_record);

Line: 279

           Pay_Za_Update_Pkg.delete_tysp_table
                         (
                          p_payroll,
                          l_tax_year
                         );