DBA Data[Home] [Help]

APPS.CSM_CSP_REQ_HEADERS_EVENT_PKG dependencies on CSM_PARTY_SITES_ACC

Line 30: AND NOT EXISTS(SELECT 1 FROM CSM_PARTY_SITES_ACC acc

26: FROM po_location_associations_all hrl, HZ_CUST_ACCT_SITES_ALL cas
27: ,CSP_REQUIREMENT_HEADERS rh
28: WHERE REQUIREMENT_HEADER_ID=b_rhId AND hrl.location_id=rh.ship_to_location_id
29: and hrl.address_id=cas.cust_acct_site_id AND hrl.org_id=cas.org_id
30: AND NOT EXISTS(SELECT 1 FROM CSM_PARTY_SITES_ACC acc
31: WHERE acc.party_site_id=cas.party_site_id
32: AND acc.user_id=b_user_id);
33:
34: PROCEDURE CSP_REQ_HEADERS_MDIRTY_I(p_requirement_header_id IN NUMBER,