APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on CSI_IEA_VALUES

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 141: where ATTRIBUTE_VALUE_ID NOT IN (SELECT ATTRIBUTE_VALUE_ID from CSI_IEA_VALUES)

137:
138: CURSOR c_deletes(b_last_run_date date) IS
139: SELECT ATTRIBUTE_VALUE_ID, RESOURCE_ID
140: from CSL_CSI_ITEM_ATTR_ACC
141: where ATTRIBUTE_VALUE_ID NOT IN (SELECT ATTRIBUTE_VALUE_ID from CSI_IEA_VALUES)
142: */
143:
144: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
145: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');

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;

Line 344: FROM CSI_IEA_VALUES

340: ,p_flow_type IN NUMBER )
341: IS
342: CURSOR c_item_attr( b_instance_id NUMBER ) IS
343: SELECT ATTRIBUTE_VALUE_ID
344: FROM CSI_IEA_VALUES
345: WHERE instance_id = b_instance_id;
346:
347: r_item_attr c_item_attr%ROWTYPE;
348: