APPS.CSM_SERVICE_REQUESTS_PKG dependencies on CSI_ITEM_INSTANCES

Line 109: FROM csi_item_instances

105: --115.10
106: CURSOR l_install_site_csr (p_customer_product_id IN number)
107: IS
108: SELECT install_location_id
109: FROM csi_item_instances
110: WHERE instance_id = p_customer_product_id
111: AND install_location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS');
112:
113:

Line 115: l_install_location_id csi_item_instances.install_location_id%TYPE;

111: AND install_location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS');
112:
113:
114: --Variable Declarations
115: l_install_location_id csi_item_instances.install_location_id%TYPE;
116: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
117: l_user_id NUMBER;
118: l_msg_count NUMBER;
119: l_msg_data VARCHAR2(240);

Line 426: FROM csi_item_instances

422: --115.10
423: CURSOR l_install_site_csr (p_customer_product_id IN number)
424: IS
425: SELECT install_location_id
426: FROM csi_item_instances
427: WHERE instance_id = p_customer_product_id
428: AND install_location_type_code = 'HZ_PARTY_SITES';
429:
430: l_install_location_id csi_item_instances.install_location_id%TYPE;

Line 430: l_install_location_id csi_item_instances.install_location_id%TYPE;

426: FROM csi_item_instances
427: WHERE instance_id = p_customer_product_id
428: AND install_location_type_code = 'HZ_PARTY_SITES';
429:
430: l_install_location_id csi_item_instances.install_location_id%TYPE;
431: --
432:
433: r_last_update_date c_last_update_date%ROWTYPE;
434: