APPS.PAY_GARN_EXEMPTION_RULES_PKG SQL Statements

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

Line: 4

  PROCEDURE pre_insert (x_exemption_rule_id     IN OUT NUMBER)
   IS
      CURSOR C2 IS SELECT pay_us_garn_exemption_rules_s.nextval FROM sys.dual;

Line: 13

  END pre_insert;

Line: 30

     SELECT name
     FROM   pay_state_rules
     WHERE  substr(jurisdiction_code, 1, 2) = x_state_code;

Line: 35

     SELECT meaning
     FROM   hr_lookups
     WHERE  lookup_type = l_lookup_type
     AND    lookup_code = l_lookup_code;

Line: 100

     SELECT  MIN(effective_start_date)
     INTO    esd
     FROM    pay_us_garn_exemption_rules_f
     WHERE   state_code = X_State_Code
     AND     GARN_CATEGORY = X_Garn_Category;