APPS.POS_PARTY_MANAGEMENT_PKG SQL Statements

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

Line: 22

      SELECT code_assignment_id
        FROM hz_code_assignments
       WHERE owner_table_name = 'HZ_PARTIES'
         AND owner_table_id = p_party_id
         AND class_category = p_category
         AND class_code     = p_code
         AND status = 'A'
         AND (end_date_active is null or end_date_active > sysdate);

Line: 211

      SELECT 1
        FROM hz_contact_points
       WHERE owner_table_id = p_partyid
         AND upper(email_address) = upper(p_emailaddress)
         AND owner_table_name = 'HZ_PARTIES'
         AND status = 'A'
        AND contact_point_type = 'EMAIL';

Line: 314

    fnd_user_pkg.updateuser
      ( x_user_name   => p_username,
        x_owner       => NULL,
        x_customer_id => x_party_id
        );

Line: 349

   FOR x IN (SELECT DISTINCT vendor_party_id
	       FROM pos_supplier_users_v
	      WHERE user_name = p_username
	      ORDER BY 1
	     ) LOOP

       l_count := l_count + 1;

Line: 379

    select distinct hz2.party_id
      into l_party_id
      from fnd_user f, hz_parties hz1, hz_parties hz2,
           hz_relationships hzr1, hz_code_assignments hca
     where f.person_party_id = hz1.party_id
       and f.user_name = p_username
       and hzr1.object_id = hz2.party_id
       and hzr1.subject_id = hz1.party_id
       and hzr1.relationship_type = 'POS_EMPLOYMENT'
       and hzr1.relationship_code = 'EMPLOYEE_OF'
       and hzr1.start_date <= sysdate
       and hzr1.end_date >= sysdate
       and hca.owner_table_id = hz2.party_id
       and hca.owner_table_name = 'HZ_PARTIES'
       and hca.class_category = 'POS_PARTICIPANT_TYPE'
       and hca.class_code = 'ENTERPRISE';

Line: 415

	SELECT 1
	  FROM per_people_f p,
	       per_all_assignments_f a,
               per_periods_of_service b
	 WHERE a.person_id = p.person_id
	   AND a.primary_flag = 'Y'
	   AND a.assignment_type = 'E'
	   AND a.period_of_service_id = b.period_of_service_id
	   AND trunc(sysdate) BETWEEN p.effective_start_date AND p.effective_end_date
	   AND trunc(sysdate) BETWEEN a.effective_start_date AND a.effective_end_date
	   AND (b.actual_termination_date>= trunc(sysdate) OR b.actual_termination_date IS NULL)
	   AND p.employee_number IS NOT NULL
           AND p.person_id = p_person_id;

Line: 433

	SELECT 1
	  FROM per_people_f p,
               per_all_assignments_f a,
               per_periods_of_placement pp
	 WHERE a.person_id = p.person_id
	   AND a.person_id = pp.person_id
	   AND a.primary_flag = 'Y'
	   AND a.assignment_type = 'C'
	   AND a.period_of_placement_date_start = pp.date_start
	   AND trunc(sysdate) between p.effective_start_date AND p.effective_end_date
	   AND trunc(sysdate) between a.effective_start_date AND a.effective_end_date
	   AND (pp.actual_termination_date>= trunc(sysdate) OR pp.actual_termination_date IS NULL)
	   AND p.npw_number IS NOT NULL
	   AND p.person_id = p_person_id;

Line: 484

	SELECT employee_id, person_party_id
	  FROM fnd_user WHERE user_id = p_userid;

Line: 510

	SELECT employee_id
	  FROM fnd_user
	 WHERE user_id = p_userid;

Line: 538

   SELECT hp.person_title
     INTO l_job_title
     FROM hz_parties hp, fnd_user fu
    WHERE hp.party_id = fu.person_party_id
      AND fu.user_id = p_user_id;