APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSI_I_VERSION_LABELS

Line 111: FROM csi_i_version_labels civ

107:
108: CURSOR c_ins_label(c_instance_id NUMBER)
109: IS
110: SELECT civ.version_label
111: FROM csi_i_version_labels civ
112: WHERE (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(civ.active_start_date,SYSDATE))
113: AND TRUNC(NVL(civ.active_end_date,SYSDATE)))
114: AND civ.instance_id = c_instance_id;
115:

Line 380: , csi_i_version_labels civ

376: FROM csm_mtl_onhand_qty_acc cqa
377: , csi_item_instances cii
378: , csi_instance_statuses iis
379: , asg_user asg
380: , csi_i_version_labels civ
381: , CSI_II_RELATIONSHIPS CIR
382: WHERE cii.inventory_item_id = cqa.inventory_item_id
383: AND cii.inv_organization_id = cqa.organization_id
384: AND cii.inv_subinventory_name = cqa.subinventory_code

Line 469: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;

465:
466:
467: TYPE instance_idTab IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
468: TYPE rel_idTab IS TABLE OF csm_ii_relationships_acc.relationship_id%TYPE INDEX BY BINARY_INTEGER;
469: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;
470: l_rel_id_lst rel_idTab;
471: l_user_id_lst asg_download.user_list;
472: l_acc_id_lst asg_download.access_list;
473: l_instance_id_lst instance_idTab;