APPS.OKS_BILL_REC_PUB dependencies on OKC_TIME_CODE_UNITS_V

Line 897: FROM Okc_time_code_units_v

893: X_QUANTITY OUT NOCOPY NUMBER
894: ) IS
895: CURSOR l_uom_csr Is
896: SELECT uom_code
897: FROM Okc_time_code_units_v
898: WHERE tce_code = 'DAY'
899: AND quantity = 1;
900:
901:

Line 6820: From Okc_time_code_units_v

6816:
6817: Cursor l_uom_csr(p_code Varchar2) Is
6818: Select tce_code
6819: ,quantity
6820: From Okc_time_code_units_v
6821: Where uom_code = p_code
6822: And active_flag = 'Y';
6823:
6824: l_tce_code varchar2(10);

Line 10768: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc

10764: /*Declaration Section*/
10765: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
10766: is
10767: SELECT 1
10768: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc
10769: WHERE TL.uom_code = okc.uom_code
10770: AND TL.uom_code = p_uom_code
10771: --AND TL.uom_class = 'Time' commented for bug#5585356
10772: AND okc.active_flag = 'Y'

Line 10894: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc

10890: /*Declaration Section*/
10891: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
10892: is
10893: SELECT 1
10894: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc
10895: WHERE TL.uom_code = okc.uom_code
10896: AND TL.uom_code = p_uom_code
10897: --AND TL.uom_class = 'Time' commented for bug#5585356
10898: AND okc.active_flag = 'Y'