APPS.PAY_US_JOB_WC_USAGES_PKG SQL Statements

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

Line: 20

SELECT job_id
FROM per_jobs
WHERE business_group_id = l_business_group_id
ORDER BY name;

Line: 26

SELECT 1
FROM pay_wc_funds wcf, pay_wc_rates wcr
WHERE wcr.wc_code = p_job_code         /* reference */
  AND wcr.fund_id = wcf.fund_id        /* for this fund */
  AND wcf.state_code = l_state_code; /* in this state */

Line: 33

SELECT 1
FROM pay_job_wc_code_usages
WHERE state_code = l_state_code
  AND business_group_id = l_business_group_id;

Line: 63

    INSERT INTO pay_job_wc_code_usages
          (state_code,
           business_group_id,
           job_id,
           wc_code)
    VALUES(l_state_code,
           l_business_group_id,
           cur_rec.job_id,
           l_default_code);