APPS.OKC_TIME_UTIL_PVT dependencies on OKC_TIME_CODE_UNITS_B

Line 74: FROM okc_time_code_units_b

70:
71: /*
72: CURSOR time_code_unit_csr (p_timeunit IN varchar2) is
73: SELECT uom_code, quantity
74: FROM okc_time_code_units_b
75: WHERE tce_code = p_timeunit
76: AND active_flag = 'Y'
77: AND quantity = 1
78: */

Line 86: --Bug 3262128 FROM okc_time_code_units_b

82: query being modified to add an OR clause with Mod, The user's entry of Quarter will be considered and the query will return 6 Quarter - Bug#1821715
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

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)

Line 646: FROM okc_time_code_units_b

642: FUNCTION get_uom_code(p_timeunit IN VARCHAR2) return VARCHAR2 IS
643:
644: CURSOR time_code_unit_csr(p_timeunit IN VARCHAR2) IS
645: SELECT uom_code
646: FROM okc_time_code_units_b
647: WHERE tce_code = p_timeunit
648: AND active_flag = 'Y'
649: AND quantity = 1;
650: