APPS.JTF_RESOURCE_UTL dependencies on HZ_PARTY_SITES

Line 773: FROM hz_party_sites hps,

769: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
770:
771: CURSOR c_support_site_id IS
772: SELECT hps.party_site_id
773: FROM hz_party_sites hps,
774: hz_party_site_uses hpsu
775: WHERE hpsu.site_use_type = 'SUPPORT_SITE'
776: AND hpsu.party_site_id = hps.party_site_id
777: AND hps.party_site_id = p_support_site_id;