APPS.OKS_BILL_REC_PUB dependencies on CS_CTR_COUNTER_VALUES_V

Line 6393: FROM Cs_ctr_counter_values_v

6389: SELECT net_reading
6390: ,value_timestamp
6391: ,counter_value_id
6392: ,counter_group_id
6393: FROM Cs_ctr_counter_values_v
6394: WHERE counter_id = p_counter_id
6395: AND decode(p_override_valid_flag,'YES',nvl(override_valid_flag,'N'),'1') = decode(p_override_valid_flag,'YES','Y','1')
6396: AND nvl(valid_flag,'N') = 'N'
6397: /* Modified by sjanakir for Bug # 7168765

Line 6477: FROM Cs_ctr_counter_values_v ccr

6473:
6474:
6475: Cursor l_ctr_value_csr(p_counter_id Number,p_override_valid_flag Varchar) Is
6476: SELECT Max(ccr.counter_value_id)
6477: FROM Cs_ctr_counter_values_v ccr
6478: WHERE ccr.counter_id = p_counter_id
6479: AND trunc(ccr.Value_timestamp) Between trunc(P_start_date) And trunc(P_end_date)
6480: AND decode(p_override_valid_flag,'YES',ccr.override_valid_flag,'1') =
6481: decode(p_override_valid_flag,'YES','Y','1')

Line 6489: FROM Cs_ctr_counter_values_v

6485: Cursor l_value_csr(p_max_ctr_id Number) Is
6486: SELECT net_reading
6487: ,counter_group_id
6488: ,value_timestamp
6489: FROM Cs_ctr_counter_values_v
6490: WHERE counter_value_id = p_max_ctr_id
6491: AND nvl(valid_flag,'N') = 'N';
6492:
6493:

Line 6498: FROM Cs_ctr_counter_values_v ccr

6494:
6495:
6496: Cursor l_ctr_daily_csr(p_counter_id Number,p_override_valid_flag Varchar) Is
6497: SELECT Max(ccr.counter_value_id)
6498: FROM Cs_ctr_counter_values_v ccr
6499: WHERE ccr.counter_id = p_counter_id
6500: AND trunc(ccr.Value_timestamp) = trunc(P_start_date)
6501: AND decode(p_override_valid_flag,'YES',ccr.override_valid_flag,'1') =
6502: decode(p_override_valid_flag,'YES','Y','1')