APPS.CSM_SERVICE_REQUESTS_PKG dependencies on HZ_PARTY_SITE_USES

Line 108: FROM hz_party_sites site, hz_party_site_uses use

104: Cursor to get the Bill to Address */
105: CURSOR c_bill_to_site_id( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
106: IS
107: SELECT use.party_site_use_id
108: FROM hz_party_sites site, hz_party_site_uses use
109: WHERE site.party_site_id = use.party_site_id
110: AND site.status= 'A'
111: AND use.site_use_type= 'BILL_TO'
112: AND use.primary_per_type = 'Y'

Line 123: FROM hz_party_sites site, hz_party_site_uses use

119: Cursor to get the Ship to Address */
120: CURSOR c_ship_to_site_id ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE)
121: IS
122: SELECT use.party_site_use_id
123: FROM hz_party_sites site, hz_party_site_uses use
124:
125: WHERE site.party_site_id = use.party_site_id
126: AND site.status= 'A'
127: AND use.site_use_type= 'SHIP_TO'