[Home] [Help]
APPS.JTF_RESOURCE_UTL dependencies on HZ_PARTY_SITE_USES
Line 776: hz_party_site_uses hpsu
772:
773: CURSOR c_support_site_id IS
774: SELECT hps.party_site_id
775: FROM hz_party_sites hps,
776: hz_party_site_uses hpsu
777: WHERE hpsu.site_use_type = 'SUPPORT_SITE'
778: AND hpsu.party_site_id = hps.party_site_id
779: AND hps.party_site_id = p_support_site_id;
780: