DBA Data[Home] [Help]

APPS.POS_SUPPLIER_ADDRESS_PKG dependencies on HZ_LOCATIONS

Line 576: l_obj_ver hz_locations.object_version_number%TYPE;

572: )
573: IS
574: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
575: l_location_rec hz_location_v2pub.location_rec_type;
576: l_obj_ver hz_locations.object_version_number%TYPE;
577:
578: CURSOR l_cur IS
579: SELECT object_version_number,location_id
580: from hz_locations

Line 580: from hz_locations

576: l_obj_ver hz_locations.object_version_number%TYPE;
577:
578: CURSOR l_cur IS
579: SELECT object_version_number,location_id
580: from hz_locations
581: where location_id =
582: (SELECT location_id
583: FROM hz_party_sites
584: WHERE party_site_id = p_party_site_id