DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on HZ_PARTY_SITES_V

Line 5688: FROM hz_party_sites_V a

5684:
5685: CURSOR dest_org_locn_cur (p_cust_id in number) is
5686: SELECT b.location_id,
5687: b.organization_id
5688: FROM hz_party_sites_V a
5689: ,PO_LOCATION_ASSOCIATIONS b
5690: WHERE a.party_site_use_id = b.SITE_USE_ID
5691: and b.customer_id = p_cust_id
5692: and primary_per_type = 'Y'