DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on HZ_LOCATIONS

Line 149: l_obj_ver hz_locations.object_version_number%TYPE;

145: x_msg_count OUT nocopy NUMBER,
146: x_msg_data OUT nocopy VARCHAR2
147: )
148: IS
149: l_obj_ver hz_locations.object_version_number%TYPE;
150:
151: CURSOR l_cur IS
152: SELECT object_version_number,location_id
153: from hz_locations

Line 153: from hz_locations

149: l_obj_ver hz_locations.object_version_number%TYPE;
150:
151: CURSOR l_cur IS
152: SELECT object_version_number,location_id
153: from hz_locations
154: where location_id =
155: (SELECT location_id
156: FROM hz_party_sites
157: WHERE party_site_id = p_request_rec.party_site_id