APPS.PAY_CA_WCB_FF_FUNCTIONS SQL Statements

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

Line: 17

  select wr.rate_id
  from   pay_wci_accounts_v wav
  ,      pay_wci_rates      wr
  where  wav.account_id     = wr.account_id
  and    wav.province       = p_jurisdiction
  and    wav.account_number = p_account_number
  and    wr.code            = p_code;

Line: 54

  select wr.rate_id
  from   pay_wci_accounts_v  wav
  ,      pay_wci_rates       wr
  ,      pay_wci_occupations wo
  ,      per_jobs            pj
  where  wav.account_id     = wr.account_id
  and    wr.rate_id         = wo.rate_id
  and    wo.job_id          = pj.job_id
  and    pj.name            = p_job
  and    wav.province       = p_jurisdiction
  and    wav.account_number = p_account_number;

Line: 89

  select nvl(rate,0)
  from   pay_wci_rates
  where  rate_id = p_rate_id;