APPS.PAY_US_GROSSUP_UPD SQL Statements

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

Line: 12

      select defined_balance_id
        into l_defbal_id
        from pay_defined_balances
       where balance_type_id = p_baltype_id
         and balance_dimension_id = p_baldim_id
         and legislation_code = 'US';

Line: 19

      update pay_defined_balances
         set grossup_allowed_flag = 'Y'
       where defined_balance_id = l_defbal_id;

Line: 23

      hr_utility.trace('Updated defined balance id : '||l_defbal_id);

Line: 28

         insert into pay_defined_balances
                       (defined_balance_id,
                        balance_type_id,
                        balance_dimension_id,
                        legislation_code,
                        force_latest_balance_flag,
                        grossup_allowed_flag
                       )
          values (pay_defined_balances_s.nextval,
                  p_baltype_id,
                  p_baldim_id,
                  'US',
                  'N',
                  'Y');

Line: 42

     hr_utility.trace('Inserted balance_type_id : '||p_baltype_id);

Line: 43

     hr_utility.trace('Inserted balance_dim_id : '||p_baldim_id);

Line: 50

PROCEDURE delete_late_bal(p_start_latest_bal_id number,
                          p_end_latest_bal_id number,
                          p_dim_id number)
IS

 l_defined_bal_id NUMBER;

Line: 60

  SELECT /*+ INDEX(pay_defined_balances PAY_DEFINED_BALANCES_FK2) */
         defined_balance_id
    FROM pay_defined_balances
   WHERE balance_dimension_id = p_dim_id;

Line: 66

   SELECT latest_balance_id
     FROM pay_assignment_latest_balances
    WHERE latest_balance_id BETWEEN p_start_latest_bal_id
                                AND p_end_latest_bal_id
      AND defined_balance_id = l_defined_bal_id;

Line: 83

   delete from pay_balance_context_values
    where latest_balance_id = latebal_rec.latest_balance_id;

Line: 89

   delete from pay_assignment_latest_balances
    where latest_balance_id = latebal_rec.latest_balance_id;

Line: 102

END delete_late_bal;