APPS.OKS_BILL_REC_PUB dependencies on OKC_TIME_CODE_UNITS_V

Line 916: FROM Okc_time_code_units_v

912: X_QUANTITY OUT NOCOPY NUMBER
913: ) IS
914: CURSOR l_uom_csr Is
915: SELECT uom_code
916: FROM Okc_time_code_units_v
917: WHERE tce_code = 'DAY'
918: AND quantity = 1;
919:
920:

Line 6852: From Okc_time_code_units_v

6848:
6849: Cursor l_uom_csr(p_code Varchar2) Is
6850: Select tce_code
6851: ,quantity
6852: From Okc_time_code_units_v
6853: Where uom_code = p_code
6854: And active_flag = 'Y';
6855:
6856: l_tce_code varchar2(10);

Line 10917: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc

10913: /*Declaration Section*/
10914: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
10915: is
10916: SELECT 1
10917: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc
10918: WHERE TL.uom_code = okc.uom_code
10919: AND TL.uom_code = p_uom_code
10920: --AND TL.uom_class = 'Time' commented for bug#5585356
10921: AND okc.active_flag = 'Y'

Line 11043: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc

11039: /*Declaration Section*/
11040: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
11041: is
11042: SELECT 1
11043: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc
11044: WHERE TL.uom_code = okc.uom_code
11045: AND TL.uom_code = p_uom_code
11046: --AND TL.uom_class = 'Time' commented for bug#5585356
11047: AND okc.active_flag = 'Y'