DBA Data[Home] [Help]

APPS.MST_WB_UTIL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 566: FROM hz_cust_acct_sites_all hzcasa,

562: WHERE wlo.wsh_location_id = p_location_id;
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