APPS.OKS_BILL_REC_PUB dependencies on CS_CTR_COUNTER_VALUES_V

Line 6419: FROM Cs_ctr_counter_values_v

6415: SELECT net_reading
6416: ,value_timestamp
6417: ,counter_value_id
6418: ,counter_group_id
6419: FROM Cs_ctr_counter_values_v
6420: WHERE counter_id = p_counter_id
6421: --AND decode(p_override_valid_flag,'YES',nvl(override_valid_flag,'N'),'1') = decode(p_override_valid_flag,'YES','Y','1') /*Removed for bug 10390945*/
6422: AND nvl(valid_flag,'N') = 'N'
6423: /* Modified by sjanakir for Bug # 7168765

Line 6497: FROM oks_k_lines_b okslin, Cs_ctr_counter_values_v ccr

6493:
6494: /*modified for ER 16432647*/
6495: Cursor l_initial_csr Is
6496: SELECT nvl(okslin.base_Reading,0) Base_reading
6497: FROM oks_k_lines_b okslin, Cs_ctr_counter_values_v ccr
6498: WHERE okslin.cle_id = p_cle_id
6499: AND okslin.counter_value_id = ccr.counter_value_id (+)
6500: AND nvl(ccr.valid_flag,'N') = 'N';
6501:

Line 6505: FROM Cs_ctr_counter_values_v ccr

6501:
6502:
6503: Cursor l_ctr_value_csr(p_counter_id Number) Is /*Removed the parameter p_override_valid_flag for bug 10390945*/
6504: SELECT (ccr.counter_value_id) /*Modified for bug:9778692*/
6505: FROM Cs_ctr_counter_values_v ccr
6506: WHERE ccr.counter_id = p_counter_id
6507: AND trunc(ccr.Value_timestamp) Between trunc(P_start_date) And trunc(P_end_date)
6508: --- AND decode(p_override_valid_flag,'YES',ccr.override_valid_flag,'1') = decode(p_override_valid_flag,'YES','Y','1') /*Removed for bug 10390945 */
6509: AND nvl(valid_flag,'N') = 'N'

Line 6517: FROM Cs_ctr_counter_values_v

6513: Cursor l_value_csr(p_max_ctr_id Number) Is
6514: SELECT net_reading
6515: ,counter_group_id
6516: ,value_timestamp
6517: FROM Cs_ctr_counter_values_v
6518: WHERE counter_value_id = p_max_ctr_id
6519: AND nvl(valid_flag,'N') = 'N';
6520:
6521:

Line 6526: FROM Cs_ctr_counter_values_v ccr

6522:
6523:
6524: Cursor l_ctr_daily_csr(p_counter_id Number) Is /*Removed the parameter p_override_valid_flag for bug 10390945*/
6525: SELECT (ccr.counter_value_id) /*Modified for bug:9778692*/
6526: FROM Cs_ctr_counter_values_v ccr
6527: WHERE ccr.counter_id = p_counter_id
6528: AND trunc(ccr.Value_timestamp) = trunc(P_start_date)
6529: --- AND decode(p_override_valid_flag,'YES',ccr.override_valid_flag,'1') = decode(p_override_valid_flag,'YES','Y','1') /*Removed for bug 10390945*/
6530: AND nvl(valid_flag,'N') = 'N'