DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on CSI_COUNTERS_B

Line 2045: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE

2041: -- csi_counter_values_v does not retrieve any row.
2042: -- split above cursor into 2 cursors.
2043: -- SATRAJEN :: Changed for USAF Backporting :: Feb 2012 :: Changed to use only the base table.
2044: SELECT 'x'
2045: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
2046: WHERE cca.source_object_code = 'CP'
2047: AND cca.source_object_id = ue.csi_item_instance_id
2048: AND cca.counter_id = cc.counter_id
2049: AND ue.unit_effectivity_id = p_ue_id

Line 2230: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE

2226: -- csi_counter_values_v does not retrieve any row.
2227: -- split above cursor into 2 cursors.
2228: -- SATRAJEN :: Changed for USAF Backporting :: Feb 2012
2229: SELECT 'x'
2230: FROM CSI_COUNTERS_B CC, csi_counter_associations cca, AHL_UNIT_EFFECTIVITIES_APP_V UE
2231: WHERE cca.source_object_code = 'CP'
2232: AND cca.source_object_id = ue.csi_item_instance_id
2233: AND cca.counter_id = cc.counter_id
2234: AND ue.unit_effectivity_id = p_ue_id