APPS.HZ_USER_PARTY_UTILS SQL Statements

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

Line: 69

    SELECT customer_id,
           employee_id
    FROM   fnd_user
    WHERE  user_name = UPPER(l_user_name);

Line: 79

    SELECT pp.party_id
    FROM   hz_parties       pp
    ,      per_all_people_f per
    WHERE  pp.orig_system_reference = 'PER:'||per.person_id
    AND    per.person_id = l_per_person_id;

Line: 93

    SELECT party.party_id,
           party.party_type,
           party.status
    FROM   hz_contact_points cp,
           hz_parties party
    WHERE upper(cp.email_address) = UPPER(l_email_address)
    AND   cp.owner_table_name     = 'HZ_PARTIES'
    AND   party.party_id          = cp.owner_table_id
    AND   party.party_type        = 'PERSON'
    AND   party.status            NOT IN ('M','D','I');

Line: 110

    SELECT per.party_id,
           per.party_type,
           per.status
    FROM   hz_contact_points cp,
           hz_relationships rel,
           hz_parties per
    WHERE upper(cp.email_address) = UPPER(l_email_address)
    AND   rel.party_id            = cp.owner_table_id
    AND   cp.owner_table_name     = 'HZ_PARTIES'
    AND   rel.subject_id          = per.party_id
    AND   per.party_type          = 'PERSON'
    AND   rel.directional_flag    = 'F'
    AND   rel.subject_table_name  = 'HZ_PARTIES'
    AND   rel.object_table_name   = 'HZ_PARTIES'
    AND   rel.status              NOT IN ('M','D','I');

Line: 305

      select hz_party_number_s.nextval into par_rec.party_number from dual;

Line: 465

    SELECT per.person_id,
           per.first_name,
           per.last_name,
           per.email_address
    FROM   per_all_people_f per
    WHERE  per.person_id = l_per_person_id
    AND    TRUNC(SYSDATE) BETWEEN effective_start_date
                          AND     effective_end_date;

Line: 509

      select hz_party_number_s.nextval into par_rec.party_number from dual;