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: 82

 /*   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: 88

     SELECT party_id
     FROM (
 	     SELECT party_id , '1-HR' ORDER_BY_SOURCE ,  effective_end_date EFFECTIVE_DATE
 	     FROM   per_all_people_f
 	     WHERE  person_id = l_per_person_id
 	     AND    party_id IS NOT NULL
 	     UNION ALL
 	     SELECT pp.party_id , '2-TCA' ORDER_BY_SOURCE ,  pp.last_update_date EFFECTIVE_DATE
 	     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
 	     AND    per.party_id IS NULL
 	     ORDER BY ORDER_BY_SOURCE ASC, EFFECTIVE_DATE desc
     )
     WHERE ROWNUM = 1;

Line: 113

    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: 130

    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: 325

      select hz_party_number_s.nextval into par_rec.party_number from dual;

Line: 485

    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: 529

      select hz_party_number_s.nextval into par_rec.party_number from dual;