DBA Data[Home] [Help]

APPS.AHL_PRD_DF_PVT dependencies on CS_CTR_COUNTER_VALUES_V

Line 2634: SELECT NVL(net_reading, 0) FROM cs_ctr_counter_values_v ctrread, cs_counter_groups_v ctrgrp,

2630: l_msg_data VARCHAR2(4000);
2631: l_msg_count NUMBER;
2632:
2633: CURSOR curr_counter_val_csr(p_unit_deferral_id IN NUMBER, p_counter_id IN NUMBER,p_deferral_effective_on IN DATE) IS
2634: SELECT NVL(net_reading, 0) FROM cs_ctr_counter_values_v ctrread, cs_counter_groups_v ctrgrp,
2635: -- AHL_UNIT_EFFECTIVITIES_APP_V UE,AHL_UNIT_DEFERRALS_B UD
2636: AHL_UNIT_EFFECTIVITIES_B UE,AHL_UNIT_DEFERRALS_B UD -- Undid app usage related blind changes
2637: WHERE ctrread.VALUE_TIMESTAMP <= p_deferral_effective_on
2638: AND ctrread.counter_group_id = ctrgrp.counter_group_id