APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on CSI_I_EXTENDED_ATTRIBS

Line 104: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea, csl_csi_item_instances_acc acc

100: r_LastRundate c_LastRundate%ROWTYPE;
101:
102: CURSOR c_insert_diffs(b_last_run_date date) IS
103: SELECT ATTRIBUTE_VALUE_ID, RESOURCE_ID
104: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea, csl_csi_item_instances_acc acc
105: WHERE civ.attribute_id = ciea.attribute_id
106: AND civ.instance_id = acc.instance_id
107: AND NVL(ciea.active_start_date, sysdate) <= sysdate
108: AND NVL(ciea.active_end_date, sysdate) >= sysdate

Line 116: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea,

112: r_insert_diffs c_insert_diffs%ROWTYPE;
113:
114: CURSOR c_updates(b_last_run_date date) IS
115: SELECT acc.ACCESS_ID, acc.RESOURCE_ID
116: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea,
117: csl_csi_item_instances_acc csiacc, CSL_CSI_ITEM_ATTR_ACC acc
118: WHERE civ.attribute_id = ciea.attribute_id
119: AND civ.instance_id = csiacc.instance_id
120: AND civ.ATTRIBUTE_VALUE_ID = acc.ATTRIBUTE_VALUE_ID

Line 129: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea, csl_csi_item_instances_acc acc

125:
126: /*
127: CURSOR c_end_dates(b_last_run_date date) IS
128: SELECT ATTRIBUTE_VALUE_ID, RESOURCE_ID
129: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea, csl_csi_item_instances_acc acc
130: WHERE civ.attribute_id = ciea.attribute_id
131: AND civ.instance_id = acc.instance_id
132: AND NVL(ciea.active_start_date, sysdate) <= sysdate
133: AND NVL(ciea.active_end_date, sysdate) < sysdate

Line 278: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea

274: ,p_flow_type IN NUMBER )
275: IS
276: CURSOR c_item_attr( b_instance_id NUMBER ) IS
277: SELECT ATTRIBUTE_VALUE_ID
278: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea
279: WHERE civ.attribute_id = ciea.attribute_id
280: AND NVL(ciea.active_start_date, sysdate) <= sysdate
281: AND NVL(ciea.active_end_date, sysdate) >= sysdate
282: AND civ.instance_id = b_instance_id;