APPS.CSI_COUNTER_READINGS_PUB dependencies on CSI_COUNTERS_B

Line 78: CSI_COUNTERS_B ccv

74: --
75: CURSOR TARGET_CUR(p_src_ctr_id IN NUMBER,p_value_timestamp IN DATE) IS
76: select ccr.object_counter_id
77: from CSI_COUNTER_RELATIONSHIPS ccr,
78: CSI_COUNTERS_B ccv
79: where ccr.source_counter_id = p_src_ctr_id
80: and ccr.relationship_type_code = l_target_rel_type
81: and nvl(ccr.active_start_date,sysdate) <= p_value_timestamp
82: and nvl(ccr.active_end_date,(sysdate+1)) > p_value_timestamp

Line 89: CSI_COUNTERS_B ccv

85: CURSOR UPD_TARGET_CUR(p_ctr_value_id IN NUMBER,p_src_ctr_id IN NUMBER) IS
86: SELECT crg.counter_id
87: from CSI_COUNTER_READINGS crg,
88: CSI_COUNTER_RELATIONSHIPS ccr,
89: CSI_COUNTERS_B ccv
90: where crg.source_counter_value_id = p_ctr_value_id
91: and ccr.object_counter_id = crg.counter_id
92: and ccr.source_counter_id = p_src_ctr_id
93: and ccr.relationship_type_code = l_target_rel_type

Line 98: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv

94: and ccv.counter_id = crg.counter_id;
95: --
96: CURSOR DERIVE_CUR(p_ctr_value_id IN NUMBER) IS
97: SELECT ctr.counter_id
98: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv
99: WHERE cv.counter_value_id = p_ctr_value_id
100: AND ctr.derive_counter_id = cv.counter_id
101: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
102: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;

Line 339: FROM csi_counters_b

335: csi_ctr_gen_utility_pvt.put_line('Calling Update_Last_Service_Reading_Wo...');
336: BEGIN
337: SELECT reading_type
338: INTO l_reading_type
339: FROM csi_counters_b
340: WHERE counter_id = p_ctr_rdg_tbl(j).counter_id;
341: EXCEPTION
342: WHEN OTHERS THEN
343: NULL;

Line 823: CSI_COUNTERS_B ccv

819: --
820: CURSOR TARGET_CUR(p_src_ctr_id IN NUMBER,p_value_timestamp IN DATE) IS
821: select ccr.object_counter_id
822: from CSI_COUNTER_RELATIONSHIPS ccr,
823: CSI_COUNTERS_B ccv
824: where ccr.source_counter_id = p_src_ctr_id
825: and ccr.relationship_type_code = l_target_rel_type
826: and nvl(ccr.active_start_date,sysdate) <= p_value_timestamp
827: and nvl(ccr.active_end_date,(sysdate+1)) > p_value_timestamp

Line 834: CSI_COUNTERS_B ccv

830: CURSOR UPD_TARGET_CUR(p_ctr_value_id IN NUMBER,p_src_ctr_id IN NUMBER) IS
831: SELECT crg.counter_id
832: from CSI_COUNTER_READINGS crg,
833: CSI_COUNTER_RELATIONSHIPS ccr,
834: CSI_COUNTERS_B ccv
835: where crg.source_counter_value_id = p_ctr_value_id
836: and ccr.object_counter_id = crg.counter_id
837: and ccr.source_counter_id = p_src_ctr_id
838: and ccr.relationship_type_code = l_target_rel_type

Line 843: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv

839: and ccv.counter_id = crg.counter_id;
840: --
841: CURSOR DERIVE_CUR(p_ctr_value_id IN NUMBER) IS
842: SELECT ctr.counter_id
843: FROM CSI_COUNTERS_B ctr, CSI_COUNTER_READINGS cv
844: WHERE cv.counter_value_id = p_ctr_value_id
845: AND ctr.derive_counter_id = cv.counter_id
846: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
847: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;