DBA Data[Home] [Help]

APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTER_READING_LOCKS

Line 1646: FROM CSI_COUNTER_READING_LOCKS

1642:
1643: Begin
1644: SELECT MAX(READING_LOCK_DATE)
1645: INTO l_rdg_lock_date
1646: FROM CSI_COUNTER_READING_LOCKS
1647: WHERE COUNTER_ID IN (SELECT OBJECT_COUNTER_ID FROM
1648: CSI_COUNTER_RELATIONSHIPS WHERE SOURCE_COUNTER_ID = p_ctr_rdg_rec.counter_id AND
1649: NVL(ACTIVE_END_DATE,(p_ctr_rdg_rec.value_timestamp + 1)) > p_ctr_rdg_rec.value_timestamp
1650: UNION ALL SELECT p_ctr_rdg_rec.counter_id FROM DUAL);

Line 5375: FROM CSI_COUNTER_READING_LOCKS

5371: l_rdg_lock_date := NULL;
5372: Begin
5373: SELECT MAX(READING_LOCK_DATE)
5374: INTO l_rdg_lock_date
5375: FROM CSI_COUNTER_READING_LOCKS
5376: WHERE COUNTER_ID IN (SELECT OBJECT_COUNTER_ID FROM
5377: CSI_COUNTER_RELATIONSHIPS WHERE SOURCE_COUNTER_ID = l_curr_ctr_rdg_rec.counter_id AND
5378: NVL(ACTIVE_END_DATE,(l_curr_ctr_rdg_rec.value_timestamp + 1)) > l_curr_ctr_rdg_rec.value_timestamp
5379: UNION ALL SELECT l_curr_ctr_rdg_rec.counter_id FROM DUAL);