APPS.CSF_WF_EVENT_SUBSCR_PKG SQL Statements

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

Line: 83

    SELECT csi.incident_id, csi.customer_product_id,
           aueb.forecast_sequence, aueb.mr_header_id
    FROM
        cs_incidents_all_b csi,
        ahl_unit_effectivities_vl aueb,
        cs_incident_links cil
    WHERE
        cil.object_id = aueb.unit_effectivity_id
        and   cil.object_type = 'AHL_UMP_EFF'
        and   cil.link_type_id = 6
        and   csi.incident_id = cil.subject_id
        and   csi.incident_number = l_request_number;

Line: 98

    SELECT csi.incident_id,aueb.unit_effectivity_id  from
    cs_incidents_all_b csi,
    ahl_unit_effectivities_vl aueb,
    cs_incident_links cil
    WHERE
    (aueb.status_code is NULL
	 or aueb.status_code = 'INIT-DUE')
    and   cil.object_id = aueb.unit_effectivity_id
    and   cil.object_type = 'AHL_UMP_EFF'
    and   cil.link_type_id = 6
    and   csi.incident_id = cil.subject_id
    and   nvl(csi.status_flag, 'O') <> 'C' and
    nvl(aueb.forecast_sequence, -1) < l_forecast_sequence and
    aueb.csi_item_instance_id = l_customer_product_id and
    nvl(aueb.mr_header_id, 0) = l_mr_header_id and
    csi.incident_id <> l_request_id;