DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 101: FROM CSI_COUNTER_ASSOCIATIONS CCA,

97: FROM
98: (SELECT UMP.unit_effectivity_id,
99: UMP.due_date,
100: (SELECT ii.counter_id
101: FROM CSI_COUNTER_ASSOCIATIONS CCA,
102: CSI_COUNTERS_VL ii,
103: CSI_COUNTER_TEMPLATE_VL tmp
104: WHERE CCA.SOURCE_OBJECT_CODE = 'CP'
105: AND CCA.SOURCE_OBJECT_ID = UMP.CSI_ITEM_INSTANCE_ID

Line 149: FROM CSI_COUNTER_ASSOCIATIONS CCA,

145: FROM
146: (SELECT UMP.unit_effectivity_id,
147: UMP.due_date,
148: (SELECT ii.counter_id
149: FROM CSI_COUNTER_ASSOCIATIONS CCA,
150: CSI_COUNTERS_VL ii,
151: CSI_COUNTER_TEMPLATE_VL tmp
152: WHERE CCA.SOURCE_OBJECT_CODE = 'CP'
153: AND CCA.SOURCE_OBJECT_ID = UMP.CSI_ITEM_INSTANCE_ID

Line 784: FROM CSI_COUNTER_ASSOCIATIONS CCA,

780: AND NVL(ccr.disabled_flag,'N') = 'N'
781: )
782: INTO l_ctr_uom,
783: l_ctr_reading
784: FROM CSI_COUNTER_ASSOCIATIONS CCA,
785: CSI_COUNTERS_VL CC
786: WHERE CCA.COUNTER_ID = CC.COUNTER_ID
787: AND CCA.SOURCE_OBJECT_ID = p_instance_id
788: AND CCA.SOURCE_OBJECT_CODE = 'CP'