APPS.ENG_WORKFLOW_NTF_UTIL SQL Statements

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

Line: 30

        SELECT message_name
        FROM   WF_NOTIFICATIONS
        WHERE  notification_id = p_nid ;

Line: 118

       SELECT 'This is To Do Ntf'
       FROM   WF_NOTIFICATIONS wfn
       WHERE  EXISTS (SELECT null
                      FROM  WF_MESSAGE_ATTRIBUTES wfma
                      WHERE wfma.subtype = 'RESPOND'
                      AND   wfma.message_name = wfn.message_name
                      AND   wfma.message_type = wfn.message_type
                      )
       AND    wfn.notification_id = p_nid ;

Line: 752

        SELECT EngineeringChangeEO.change_id,
               EngineeringChangeEO.change_mgmt_type_code ,
               ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE
        FROM ENG_ENGINEERING_CHANGES EngineeringChangeEO,
             ENG_CHANGE_ORDER_TYPES ChangeCategory
        WHERE (  ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE = 'ATTACHMENT_APPROVAL'
              OR ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE = 'ATTACHMENT_REVIEW'
              OR NOT EXISTS (select null
                             from eng_change_type_applications type_appl
                             where type_appl.change_type_id = ChangeCategory.change_order_type_id
                             and type_appl.application_id = 431)
                             )
        AND ChangeCategory.type_classification = 'CATEGORY'
        AND ChangeCategory.change_mgmt_type_code = EngineeringChangeEO.change_mgmt_type_code
        AND EngineeringChangeEO.change_id = p_change_id  ;

Line: 1533

        SELECT u.USER_NAME
             , u.USER_ID
             , u.PARTY_ID
             , u.PARTY_NAME
        FROM   EGO_USER_V u
             , WF_NOTIFICATIONS wn
        WHERE u.USER_NAME = wn.RECIPIENT_ROLE
        AND   wn.NOTIFICATION_ID = c_ntf_id ;