APPS.JTF_RS_RESOURCE_WF_PUB dependencies on HZ_PARTY_SITES

Line 136: FROM hz_locations a, hz_party_site_uses c, hz_party_sites b

132: WHERE upgrade_tz_id = l_timezone_id;
133:
134: CURSOR c_support_site (l_support_site_id number) IS
135: SELECT a.city
136: FROM hz_locations a, hz_party_site_uses c, hz_party_sites b
137: WHERE c.site_use_type = 'SUPPORT_SITE'
138: AND c.party_site_id = b.party_site_id
139: AND a.location_id = b.location_id
140: AND b.party_site_id = l_support_site_id;