APPS.AS_LEAD_ABANDON_WF SQL Statements

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

Line: 31

    SELECT TO_CHAR(AS_WORKFLOW_KEYS_S.nextval)
    INTO Item_Key
    FROM dual;

Line: 174

        SELECT b.business_group_id
        FROM jtf_rs_emp_dtls_vl a,
             per_assignments_x b
        WHERE a.source_id = b.person_id
              and b.primary_flag = 'Y'
              and b.assignment_type = 'E'
              and a.resource_id = resource_id_in
        ORDER BY resource_id;