APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on CSI_COUNTERS_B

Line 9634: FROM csi_counters_b cc, csi_counter_readings ccr

9630: AND cca.counter_id = cv.counter_id)
9631: AND rownum < 2;
9632: */
9633: select nvl(ccr.net_reading,0) net_reading
9634: FROM csi_counters_b cc, csi_counter_readings ccr
9635: WHERE cc.counter_id = p_counter_id
9636: and ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO;
9637:
9638: i NUMBER;

Line 14542: FROM csi_counters_b cc, csi_counter_readings ccr

14538: CURSOR cs_ctr_counter_csr (--p_csi_item_instance_id IN NUMBER,
14539: p_counter_id IN NUMBER) IS
14540:
14541: select nvl(ccr.net_reading,0) net_reading
14542: FROM csi_counters_b cc, csi_counter_readings ccr
14543: WHERE cc.counter_id = p_counter_id
14544: and ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO;
14545:
14546: i NUMBER;

Line 16252: FROM csi_counters_b cc, csi_counter_readings ccr

16248:
16249: -- get the counter usage
16250: CURSOR cs_ctr_counter_csr (p_counter_id IN NUMBER) IS
16251: select nvl(ccr.net_reading,0) net_reading
16252: FROM csi_counters_b cc, csi_counter_readings ccr
16253: WHERE cc.counter_id = p_counter_id
16254: and ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO;
16255:
16256:

Line 16260: SELECT aut.counter_id, aut.counter_value, (select uom_code from csi_counters_b where counter_id = aut.counter_id) uom_code

16256:
16257: -- added for USAF: Assembly Maint. Enh.: Support for initializing a NR.
16258: -- Get threshold details.
16259: CURSOR ahl_unit_threshold_csr (p_ue_id IN NUMBER) IS
16260: SELECT aut.counter_id, aut.counter_value, (select uom_code from csi_counters_b where counter_id = aut.counter_id) uom_code
16261: FROM ahl_unit_thresholds aut, ahl_unit_deferrals_b udf
16262: WHERE udf.unit_effectivity_id = p_ue_id
16263: AND udf.unit_deferral_id = aut.unit_deferral_id
16264: AND udf.unit_deferral_type = 'INIT-DUE';