DBA Data[Home] [Help]

APPS.MST_WB_UTIL dependencies on HZ_PARTY_SITES

Line 567: hz_party_sites hzps,

563:
564: CURSOR chk_cust_site(p_location_id IN NUMBER, p_owner_party_id IN NUMBER) IS
565: SELECT 1
566: FROM hz_cust_acct_sites_all hzcasa,
567: hz_party_sites hzps,
568: hz_cust_accounts hzc
569: WHERE hzc.party_id = hzps.party_id
570: AND hzps.location_id = p_location_id
571: AND hzps.party_site_id = hzcasa.party_site_id