APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on HZ_LOCATIONS

Line 822: FROM hz_party_sites p, hz_locations loc, hz_party_site_uses psu

818: -- Get the total count if "Last" hyperlink is clicked
819: IF (p_range_high < 0) THEN
820: SELECT count(*)
821: INTO l_total_count
822: FROM hz_party_sites p, hz_locations loc, hz_party_site_uses psu
823: WHERE UPPER(loc.address1) like l_display_value
824: AND p.party_site_id = psu.party_site_id
825: AND psu.site_use_type = 'SUPPORT_SITE'
826: AND p.location_id = loc.location_id;

Line 843: FROM hz_party_sites p, hz_locations loc, hz_party_site_uses psu

839:
840:
841: OPEN lov_output_cur FOR
842: SELECT loc.address1, to_char(p.party_site_id), loc.city, null, null, null, null, null, null, null
843: FROM hz_party_sites p, hz_locations loc, hz_party_site_uses psu
844: WHERE UPPER(loc.address1) like l_display_value
845: AND p.party_site_id = psu.party_site_id
846: AND psu.site_use_type = 'SUPPORT_SITE'
847: AND p.location_id = loc.location_id