APPS.JTF_EBI_PUB SQL Statements

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

Line: 12

  SELECT START_DATE_ACTIVE, END_DATE_ACTIVE into x_start_date, x_end_date
  FROM   JTF_RS_RESOURCE_EXTNS
  WHERE  RESOURCE_ID = p_resource_id;

Line: 32

  UPDATE JTF_RS_SALESREPS_INT
  SET    OPERATION = 'NO-OP'
  WHERE  RESOURCE_ID = p_resource_id
  AND    ORG_ID = p_org_id
  AND    INTERFACE_ID <> p_interface_id
  AND    BATCH_ID = p_batch_id;

Line: 71

    UPDATE JTF_RS_RESOURCE_EXTNS_INT set start_date_active = null where operation = 'UPDATE' and batch_id = p_batch_id;

Line: 125

    SELECT
     interface_id, resource_id, org_id, start_date_active, end_date_active, operation
    FROM
     jtf_rs_salesreps_int
    WHERE
     batch_id  = p_batch_id
    ORDER BY
     interface_id;

Line: 149

    SELECT OPERATION INTO L_OPERATION FROM JTF_RS_SALESREPS_INT WHERE INTERFACE_ID = CUR.INTERFACE_ID;

Line: 157

      UPDATE JTF_RS_SALESREPS_INT
      SET    START_DATE_ACTIVE = l_start_date, END_DATE_ACTIVE = l_end_date
      WHERE  INTERFACE_ID = cur.INTERFACE_ID;