APPS.CSI_COUNTER_READINGS_PUB dependencies on CSI_COUNTER_RELATIONSHIPS

Line 70: from csi_counter_relationships

66: ORDER BY value_timestamp asc, counter_value_id asc;
67: --
68: CURSOR FORMULA_CUR(p_src_ctr_id IN NUMBER) IS
69: select distinct object_counter_id
70: from csi_counter_relationships
71: where source_counter_id = p_src_ctr_id
72: and relationship_type_code = l_formula_rel_type
73: and nvl(active_end_date,(sysdate+1)) > sysdate;
74: --

Line 77: from CSI_COUNTER_RELATIONSHIPS ccr,

73: and nvl(active_end_date,(sysdate+1)) > sysdate;
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

Line 88: CSI_COUNTER_RELATIONSHIPS ccr,

84: --
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

Line 815: from csi_counter_relationships

811: l_assembler_tbl T_NUM;
812: --
813: CURSOR FORMULA_CUR(p_src_ctr_id IN NUMBER) IS
814: select distinct object_counter_id
815: from csi_counter_relationships
816: where source_counter_id = p_src_ctr_id
817: and relationship_type_code = l_formula_rel_type
818: and nvl(active_end_date,(sysdate+1)) > sysdate;
819: --

Line 822: from CSI_COUNTER_RELATIONSHIPS ccr,

818: and nvl(active_end_date,(sysdate+1)) > sysdate;
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

Line 833: CSI_COUNTER_RELATIONSHIPS ccr,

829: --
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