APPS.CSI_FA_INSTANCE_GRP dependencies on CSI_ITEM_INSTANCES_H

Line 83: FROM csi_item_instances_h ciih,

79: AND sysdate BETWEEN nvl(cia.active_start_date, sysdate-1) AND nvl(cia.active_end_date, sysdate+1);
80:
81: CURSOR pending_txn_cur(p_instance_id in number) is
82: SELECT ct.transaction_id
83: FROM csi_item_instances_h ciih,
84: csi_transactions ct
85: WHERE ciih.instance_id = p_instance_id
86: AND ct.transaction_id = ciih.transaction_id
87: AND ct.transaction_type_id IN (117, 129, 128, 105, 112, 118, 119)