APPS.OKC_TIME_UTIL_PVT dependencies on OKC_TIME_CODE_UNITS_V

Line 22: FROM okc_time_code_units_v

18: we are checking the active rows first instead of filtering using
19: active_flag = Y */
20: CURSOR time_code_unit_csr (p_uom_code IN varchar2) IS
21: SELECT tce_code, quantity
22: FROM okc_time_code_units_v
23: WHERE uom_code = p_uom_code
24: ORDER BY decode(active_flag,'Y',1,2);
25:
26: /* Commented for bug 1787982

Line 29: from okc_time_code_units_v

25:
26: /* Commented for bug 1787982
27: CURSOR time_code_unit_csr (p_uom_code IN varchar2) is
28: select tce_code, quantity
29: from okc_time_code_units_v
30: where uom_code = p_uom_code; */
31:
32: l_row_not_found BOOLEAN := TRUE;
33: time_code_unit_rec time_code_unit_csr%ROWTYPE;

Line 99: from okc_time_code_units_v

95:
96: /* Commented for bug 1787982
97: CURSOR time_code_unit_csr (p_timeunit IN varchar2) is
98: select uom_code
99: from okc_time_code_units_v
100: where tce_code = p_timeunit
101: and quantity = 1; */
102:
103: l_row_not_found BOOLEAN := TRUE;