APPS.POS_ENTERPRISE_UTIL_PKG SQL Statements

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

Line: 12

      SELECT hp.party_id, hp.party_name
	FROM hz_parties hp, hz_code_assignments hca
    	WHERE hca.owner_table_id = hp.party_id
    	  AND hca.owner_table_name = 'HZ_PARTIES'
    	  AND hca.class_category = 'POS_PARTICIPANT_TYPE'
    	  AND hca.class_code = 'ENTERPRISE'
    	  AND hca.status= 'A'
    	  AND hp.status= 'A'
    	  AND ( hca.end_date_active > sysdate or hca.end_date_active is null );

Line: 79

      SELECT hp.party_id, hp.party_name
	FROM hz_parties hp, hz_code_assignments hca
    	WHERE hca.owner_table_id = hp.party_id
    	  AND hca.owner_table_name = 'HZ_PARTIES'
    	  AND hca.class_category = 'POS_PARTICIPANT_TYPE'
    	  AND hca.class_code = 'ENTERPRISE'
    	  AND hca.status= 'A'
    	  AND hp.status= 'A'
	  AND ( hca.end_date_active > sysdate or hca.end_date_active is null );

Line: 151

    select user_id
    into l_user_id
    from fnd_user
    where user_name = p_username;