DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on HZ_PARTY_SITES_V

Line 6045: FROM hz_party_sites_V a

6041:
6042: CURSOR dest_org_locn_cur (p_cust_id in number) is
6043: SELECT b.location_id,
6044: b.organization_id
6045: FROM hz_party_sites_V a
6046: ,PO_LOCATION_ASSOCIATIONS b
6047: WHERE a.party_site_use_id = b.SITE_USE_ID
6048: and b.customer_id = p_cust_id
6049: and primary_per_type = 'Y'