APPS.ONT_ICP_GET_USER_DETAILS SQL Statements

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

Line: 17

      SELECT employee_id,customer_id
      FROM fnd_user
      WHERE user_id = in_user;

Line: 23

	 SELECT party_name,party_type,party_id
	  FROM  hz_parties
      WHERE  party_id = in_customer_id;

Line: 28

	 SELECT cust_account_id,
		   party_name
        FROM hz_parties h,hz_cust_accounts c
       WHERE c.party_id = h.party_id
	    AND h.party_id = ( SELECT object_id
						FROM hz_relationships r
                             WHERE r.party_id = in_party_id
 AND   r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
 AND   r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
 AND   r.DIRECTIONAL_FLAG = 'F'
                          );

Line: 41

	 SELECT cust_account_role_id,party_name
	   FROM hz_parties h,hz_cust_account_roles c
       WHERE c.party_id = h.party_id
	    AND h.party_id = ( SELECT subject_id
						FROM hz_relationships r
                             WHERE r.party_id = in_party_id
 AND   r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
 AND   r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
 AND   r.DIRECTIONAL_FLAG = 'F'                          );

Line: 53

      SELECT full_name
      FROM per_all_people_f
      WHERE person_id = in_employee;