APPS.UMX_REGISTER_USER_PVT SQL Statements

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

Line: 444

      select email_address
      from   hz_parties
      where  party_id = p_person_party_id;

Line: 449

      select hzp_rel.email_address
      from  hz_parties hzp_rel, hz_relationships hzr
      where hzr.subject_id = p_person_party_id
      and   hzr.party_id = hzp_rel.party_id
      and   hzp_rel.email_address is not null;

Line: 687

    select 'Y' from fnd_user where user_name = p_user_name;