APPS.OZF_CLAIM_SETTLEMENT_WF_PVT SQL Statements

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

Line: 28

  select  ppl.person_id source_id
  from jtf_rs_resource_extns rsc , per_people_f ppl
  where rsc.category = 'EMPLOYEE' and ppl.person_id = rsc.source_id
  and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
  and rsc.resource_id = p_user_id;

Line: 305

  SELECT cust.customer_trx_id       --"settlement_id"
  , cust.cust_trx_type_id           --"settlement_type_id"
  , cust.trx_number                 --"settlement_number"
  , cust.trx_date                   --"settlement_date"
  , pay.amount_due_original       --"settlement_amount"
  , pay.status                      --"status_code"
  FROM ra_customer_trx cust
  , ar_payment_schedules pay
  WHERE cust.complete_flag = 'Y'
  AND cust.customer_trx_id = pay.customer_trx_id
  AND cust.interface_header_attribute1 = cv_claim_number;