[Home] [Help]
444: AND site_use_code = l_site_type;
445:
446: CURSOR party_site_use(l_party_site_id NUMBER, l_site_type VARCHAR2) IS
447: SELECT party_site_use_id
448: FROM hz_party_site_uses
449: WHERE party_site_id = l_party_site_id
450: AND site_use_type = l_Site_type;
451:
452: CURSOR C_location(l_party_site_id NUMBER) IS