APPS.UMX_REGISTRATION_PVT SQL Statements

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

Line: 8

      SELECT REG.REQUESTED_FOR_USER_ID, FU.USER_NAME, FU.PERSON_PARTY_ID,
             REG.STATUS_CODE
      FROM FND_USER FU, UMX_REG_REQUESTS REG
      WHERE REG.REG_REQUEST_ID = p_reg_request_id
      AND   REG.REQUESTED_FOR_USER_ID = FU.USER_ID;

Line: 139

      select UMX_REG_REQUESTS_S.nextval into l_item_key from dual;

Line: 218

      select ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY,
             POSTAL_CODE, PROVINCE, STATE, COUNTY, COUNTRY
      from hz_parties
      where party_id = p_party_id;

Line: 301

      select name
      from   wf_events
      where  guid = HEXTORAW(p_event_guid);

Line: 337

      SELECT regreq.WF_ROLE_NAME, regreq.REG_SERVICE_TYPE, regser.APPLICATION_ID,
             regreq.AME_APPLICATION_ID, regreq.AME_TRANSACTION_TYPE_ID,
             regser.EMAIL_VERIFICATION_FLAG, func.FUNCTION_NAME, regser.DISPLAY_NAME,
             regser.DESCRIPTION, regreq.JUSTIFICATION, regreq.REQUESTED_BY_USER_ID,
             regreq.REQUESTED_FOR_USER_ID, regreq.REQUESTED_FOR_PARTY_ID,
             regreq.REQUESTED_USERNAME, regser.wf_notification_event_guid,
             regser.wf_bus_logic_event_guid
      FROM   UMX_REG_SERVICES_VL regser, fnd_form_functions func,
             UMX_REG_REQUESTS regreq
      WHERE  regser.reg_function_id = func.function_id (+)
      AND    regreq.REG_SERVICE_CODE = regser.REG_SERVICE_CODE
      AND    regreq.reg_request_id = p_reg_request_id;

Line: 414

      SELECT regser.WF_ROLE_NAME, regser.REG_SERVICE_TYPE, regser.APPLICATION_ID,
             regser.wf_notification_event_guid, regser.AME_APPLICATION_ID,
             regser.AME_TRANSACTION_TYPE_ID, regser.EMAIL_VERIFICATION_FLAG,
             func.FUNCTION_NAME, regser.DISPLAY_NAME, regser.DESCRIPTION,
             regser.wf_bus_logic_event_guid
      FROM   UMX_REG_SERVICES_VL regser, fnd_form_functions func
      WHERE  regser.reg_function_id = func.function_id (+)
      AND    REG_SERVICE_CODE = p_reg_service_code;

Line: 474

        select REG_SERVICE_TYPE, REG_SERVICE_CODE, AME_APPLICATION_ID,
               AME_TRANSACTION_TYPE_ID, REG_FUNCTION_ID,
               wf_notification_event_guid, EMAIL_VERIFICATION_FLAG,
               wf_bus_logic_event_guid
        from   UMX_REG_SERVICES_B
        where  WF_ROLE_NAME = p_wf_role_name
        and    reg_service_type = p_reg_serivce_type;

Line: 873

      select user_name
      from   fnd_user
      where  user_id = l_userid;

Line: 878

      select person_party_id
      from   fnd_user
      where  user_id = l_userid;

Line: 1177

      select umx_events_s.nextval into l_event_key from dual;

Line: 1265

    UMX_REG_REQUESTS_PKG.insert_row (
        x_reg_request_id   => l_reg_request_id ,
        x_reg_service_type => l_reg_service_type,
        x_status_code => l_status_code,
        x_requested_by_user_id => l_requested_by_user_id,
        x_requested_for_user_id => l_requested_for_user_id,
        x_requested_for_party_id => l_requested_for_party_id,
        x_requested_username => l_requested_username,
        x_requested_start_date => l_requested_start_date,
        x_requested_end_date => l_requested_end_date,
        x_wf_role_name => l_wf_role_name,
        x_reg_service_code => l_reg_service_code,
        x_ame_application_id => l_ame_application_id,
        x_ame_transaction_type_id => l_ame_transaction_type_id,
        x_justification => l_justification);

Line: 1320

 select perph.phone_number
 from   per_phones perph
 where  perph.phone_type = 'W1'
 and    perph.parent_id = p_person_id
 and    perph.parent_table = 'PER_ALL_PEOPLE_F'
 and    perph.date_from <= sysdate
 and    nvl(perph.date_to, sysdate + 1) > sysdate;

Line: 1388

 select mgr.full_name
 from   per_all_assignments_f emp, per_all_people_f mgr
 where  emp.supervisor_id = mgr.person_id
 and    emp.person_id = p_person_id
 and    emp.effective_start_date <= sysdate
 and    nvl(emp.effective_end_date, sysdate + 1) > sysdate
 and    mgr.effective_start_date <= sysdate
 and    nvl(mgr.effective_end_date, sysdate + 1) > sysdate;

Line: 1415

 select name
 from   per_all_assignments_f emp, per_jobs_vl jobs
 where  emp.person_id = p_person_id
 and    emp.effective_start_date <= sysdate
 and    nvl(emp.effective_end_date, sysdate + 1) > sysdate
 and    emp.job_id = jobs.job_id
 and    jobs.date_from <= sysdate
 and    nvl(jobs.date_to, sysdate + 1) > sysdate;