APPS.FND_OAM_USER_INFO SQL Statements

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

Line: 42

        select u.user_id, nvl(u.employee_id, -1),
               nvl(u.customer_id, -1), nvl(u.supplier_id, -1),
               user_guid
            into v_user_id, v_employee_id, v_customer_id,
                 v_supplier_id, user_guid
            from fnd_user u
            where upper(user_name) = upper(p_username);

Line: 66

            SELECT
                   per.full_name,
                   per.email_address,
                   usr.fax
            INTO full_name, email, fax
            FROM
                   fnd_user usr,
                   per_all_people_f per
            WHERE
                   trunc(SYSDATE) between per.effective_start_date
                                  and per.effective_end_date
                   and per.person_id = usr.employee_id
                   and usr.user_id = v_user_id;

Line: 83

              select phone_number
              into phone
              from per_phones
              where phone_type = 'W1'
              and parent_table = 'PER_ALL_PEOPLE_F'
              and sysdate between nvl(date_from, sysdate - 1)
              and nvl(date_to, sysdate + 1)
              and parent_id = v_employee_id;

Line: 99

            SELECT
                   hz.PERSON_NAME_SUFFIX,
                   hz.PERSON_FIRST_NAME,
                   hz.PERSON_LAST_NAME,
                   hz.email_address,
                   usr.fax
            INTO suffix, first_name, last_name, email, fax
            FROM
                   fnd_user usr,
                   hz_parties hz
            WHERE
                   (hz.party_id = usr.customer_id
                        OR hz.party_id = usr.supplier_id)
                   and usr.user_id = v_user_id;

Line: 146

    SELECT  party_id
      INTO  l_emp_person_party_id
      FROM  per_all_people_f
     WHERE  person_id = p_employee_id
       AND  trunc(sysdate) between effective_start_date and effective_end_date
     UNION
    SELECT  party_id
      FROM  per_all_people_f p
     WHERE  p.person_id = p_employee_id
       AND  p.effective_start_date = (SELECT min(p2.effective_start_date)
                                        FROM per_all_people_f p2
                                       WHERE p2.person_id = p.person_id)
       AND  p.effective_start_date > trunc(sysdate);

Line: 170

    select PARTY_TYPE, PARTY_NAME
      into P_PARTY_TYPE, P_PARTY_NAME
      from HZ_PARTIES
     where PARTY_ID = P_PARTY_ID;

Line: 184

    select PARTY_TYPE, PARTY_ID
      into P_PARTY_TYPE, P_PARTY_ID
      from HZ_PARTIES
     where PARTY_NAME = P_PARTY_NAME;

Line: 204

    select distinct rel.subject_id
      into l_cust_person_party_id
      from hz_relationships rel
     where rel.party_id = p_customer_id
       and rel.subject_table_name = 'HZ_PARTIES'
       and rel.subject_type = 'PERSON'
       and rel.object_table_name = 'HZ_PARTIES'
       and rel.object_type = 'ORGANIZATION';