APPS.AHL_PRD_PRINT_PVT dependencies on CSI_COUNTER_READINGS

Line 2859: FROM csi_counter_readings ccr

2855:
2856: l_counter_det VARCHAR2(1000) := '
2857: SELECT cc.counter_template_name "CounterName",
2858: (SELECT ccr.net_reading
2859: FROM csi_counter_readings ccr
2860: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2861: AND NVL(ccr.disabled_flag,''N'') = ''N''
2862: )
2863: "CurrentReading"

Line 2879: FROM csi_counter_readings ccr

2875:
2876: l_counter_details VARCHAR2(500) := '
2877: SELECT cc.counter_template_name "CounterName",
2878: (SELECT ccr.net_reading
2879: FROM csi_counter_readings ccr
2880: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2881: AND NVL(ccr.disabled_flag,''N'') = ''N''
2882: )
2883: "CurrentReading"

Line 3249: from csi_counter_readings ccr

3245: IF (l_unit_eff_id is not null) THEN
3246: BEGIN
3247: select counter_value,
3248: (select ccr.net_reading
3249: from csi_counter_readings ccr
3250: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
3251: and nvl(ccr.disabled_flag,'N') = 'N') net_reading
3252: into l_counter_value, l_net_reading
3253: from ahl_unit_accomplishmnts ua, csi_counter_associations cca, csi_counters_vl cc

Line 8327: FROM csi_counter_readings ccr

8323:
8324: l_counter_det VARCHAR2(1000) := '
8325: SELECT cc.counter_template_name "CounterName",
8326: (SELECT ccr.net_reading
8327: FROM csi_counter_readings ccr
8328: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
8329: AND NVL(ccr.disabled_flag,''N'') = ''N''
8330: )
8331: "CurrentReading"

Line 8347: FROM csi_counter_readings ccr

8343:
8344: l_counter_details VARCHAR2(500) := '
8345: SELECT cc.counter_template_name "CounterName",
8346: (SELECT ccr.net_reading
8347: FROM csi_counter_readings ccr
8348: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
8349: AND NVL(ccr.disabled_flag,''N'') = ''N''
8350: )
8351: "CurrentReading"