APPS.CSI_COUNTER_READINGS_PUB dependencies on CSI_COUNTER_RELATIONSHIPS

Line 69: from csi_counter_relationships

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

Line 76: from CSI_COUNTER_RELATIONSHIPS ccr,

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

Line 87: CSI_COUNTER_RELATIONSHIPS ccr,

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

Line 784: from csi_counter_relationships

780: l_assembler_tbl T_NUM;
781: --
782: CURSOR FORMULA_CUR(p_src_ctr_id IN NUMBER) IS
783: select distinct object_counter_id
784: from csi_counter_relationships
785: where source_counter_id = p_src_ctr_id
786: and relationship_type_code = l_formula_rel_type
787: and nvl(active_end_date,(sysdate+1)) > sysdate;
788: --

Line 791: from CSI_COUNTER_RELATIONSHIPS ccr,

787: and nvl(active_end_date,(sysdate+1)) > sysdate;
788: --
789: CURSOR TARGET_CUR(p_src_ctr_id IN NUMBER,p_value_timestamp IN DATE) IS
790: select ccr.object_counter_id
791: from CSI_COUNTER_RELATIONSHIPS ccr,
792: CSI_COUNTERS_B ccv
793: where ccr.source_counter_id = p_src_ctr_id
794: and ccr.relationship_type_code = l_target_rel_type
795: and nvl(ccr.active_start_date,sysdate) <= p_value_timestamp

Line 802: CSI_COUNTER_RELATIONSHIPS ccr,

798: --
799: CURSOR UPD_TARGET_CUR(p_ctr_value_id IN NUMBER,p_src_ctr_id IN NUMBER) IS
800: SELECT crg.counter_id
801: from CSI_COUNTER_READINGS crg,
802: CSI_COUNTER_RELATIONSHIPS ccr,
803: CSI_COUNTERS_B ccv
804: where crg.source_counter_value_id = p_ctr_value_id
805: and ccr.object_counter_id = crg.counter_id
806: and ccr.source_counter_id = p_src_ctr_id