APPS.CSI_EXTEND_ATTRIB_VLD_PVT dependencies on CSI_ITEM_INSTANCES

Line 37: FROM csi_item_instances

33: SELECT inventory_item_id,
34: inv_master_organization_id
35: INTO p_inventory_item_id,
36: p_inv_master_org_id
37: FROM csi_item_instances
38: WHERE instance_id = p_instance_id
39: AND ((active_end_date is NULL) OR (TRUNC(active_end_date,'MI') >= TRUNC(SYSDATE,'MI')));--Changed to trunc for bug 9756224
40:
41: RETURN TRUE;

Line 383: FROM csi_item_instances

379:
380: CURSOR c1 IS
381: SELECT active_start_date,
382: active_end_date
383: FROM csi_item_instances
384: WHERE instance_id = p_instance_id;
385: l_date_rec c1%ROWTYPE;
386:
387: BEGIN

Line 459: FROM csi_item_instances

455:
456: CURSOR c1 IS
457: SELECT active_start_date,
458: active_end_date
459: FROM csi_item_instances
460: WHERE instance_id = p_instance_id;
461:
462: l_date_rec c1%ROWTYPE;
463: