APPS.CSD_ESTIMATE_UTILS_PVT dependencies on CSI_ITEM_INSTANCES

Line 295: FROM CSI_ITEM_INSTANCES

291: FUNCTION VALIDATE_ITEM_INSTANCE(p_instance_id NUMBER) RETURN VARCHAR2 IS
292:
293: CURSOR c1 IS
294: SELECT INSTANCE_NUMBER
295: FROM CSI_ITEM_INSTANCES
296: WHERE INSTANCE_ID = p_instance_id;
297:
298: l_instance_number VARCHAR2(30);
299: BEGIN

Line 1002: FROM csi_item_instances

998: AND BILLING_TYPE = p_billing_Type;
999:
1000: CURSOR CUR_ITEM_INSTANCE(p_item_id NUMBER, p_serial_number NUMBER) IS
1001: SELECT instance_number, instance_id
1002: FROM csi_item_instances
1003: WHERE inventory_item_id = p_item_id
1004: AND serial_number = p_serial_number;
1005:
1006: l_billing_Type VARCHAR2(1);