97: CURSOR c_bill_to_site_id
98: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
99: ) IS
100: SELECT use.party_site_use_id FROM
101: hz_party_sites site, hz_party_site_uses use
102: WHERE site.party_site_id = use.party_site_id
103: AND site.status= 'A'
104: AND use.site_use_type= 'BILL_TO'
105: AND use.primary_per_type = 'Y'
113: CURSOR c_ship_to_site_id
114: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
115: ) IS
116: SELECT use.party_site_use_id FROM
117: hz_party_sites site, hz_party_site_uses use
118: WHERE site.party_site_id = use.party_site_id
119: AND site.status= 'A'
120: AND use.site_use_type= 'SHIP_TO'
121: AND use.primary_per_type = 'Y'