APPS.GMO_MBR_UTIL SQL Statements

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

Line: 36

       SELECT distinct b.STATUS,
              EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE',b.GUID) map_code
       from wf_events_vl a,
            wf_event_subscriptions b
       WHERE a.guid=b.EVENT_FILTER_GUID
         and b.RULE_FUNCTION ='EDR_PSIG_RULE.PSIG_RULE'
         and a.name = p_event_name
       ORDER BY b.STATUS DESC;

Line: 45

    select count(*) INTO l_cnt
    from   wf_events_vl a,
           wf_event_subscriptions b
    WHERE a.guid=b.EVENT_FILTER_GUID
      and b.RULE_FUNCTION ='EDR_PSIG_RULE.PSIG_RULE'
      and b.status = 'ENABLED'
      and a.name = p_event_name;

Line: 142

  Select substr(P_MBR_EVT_KEY,
                      to_number(instr(P_MBR_EVT_KEY,'-'))+1,
                      decode(instr(P_MBR_EVT_KEY,'-',1,2),0,length(P_MBR_EVT_KEY),
                      to_number(instr(P_MBR_EVT_KEY,'-',1,2))-to_number(instr(P_MBR_EVT_KEY,'-'))-1))
  into l_org_id  from dual;

Line: 148

  SELECT hou.name ORGANIZATION_NAME , mp.organization_code ORGANIZATION_CODE into X_ORG_NAME,X_ORG_CODE
      FROM hr_all_organization_units hou, mtl_parameters mp
      WHERE hou.organization_id = l_org_id
         and mp.organization_id = hou.organization_id;

Line: 171

Select substr(P_MBR_EVT_KEY,
                      to_number(instr(P_MBR_EVT_KEY,'-'))+1,
                      decode(instr(P_MBR_EVT_KEY,'-',1,2),0,length(P_MBR_EVT_KEY),
                      to_number(instr(P_MBR_EVT_KEY,'-',1,2))-to_number(instr(P_MBR_EVT_KEY,'-'))-1))
  into G_ORGANIZATION_ID  from dual;