DBA Data[Home] [Help]

APPS.OKC_TIME_UTIL_PVT dependencies on OKX_UNITS_OF_MEASURE_V

Line 87: FROM okc_time_code_units_b TCU,okx_units_of_measure_v UOM

83: */
84: CURSOR time_code_unit_csr (p_timeunit IN varchar2, p_duration IN NUMBER) is
85: SELECT TCU.uom_code, TCU.quantity
86: --Bug 3262128 FROM okc_time_code_units_b
87: FROM okc_time_code_units_b TCU,okx_units_of_measure_v UOM
88: WHERE TCU.tce_code = p_timeunit
89: AND TCU.active_flag = 'Y'
90: --Bug 3262128 added condition to check for disable_date of UOM
91: and nvl(UOM.disable_date,trunc(sysdate)) >= trunc(sysdate)