APPS.PV_PARTNER_UTIL_PVT dependencies on HZ_PARTY_SITE_USES

Line 794: FROM hz_party_site_uses hpsu,

790:
791:
792: CURSOR get_site_use_type(cv_party_id NUMBER) IS
793: SELECT distinct site_use_type
794: FROM hz_party_site_uses hpsu,
795: hz_party_sites hps
796: WHERE hpsu.party_site_id = hps.party_site_id
797: AND site_use_type in ('SHIP_TO','BILL_TO')
798: AND hps.party_id = cv_party_id ;