DBA Data[Home] [Help]

APPS.OKS_TIME_MEASURES_PUB dependencies on MTL_UNITS_OF_MEASURE_TL

Line 517: FROM MTL_UNITS_OF_MEASURE_TL

513:
514: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
515: is
516: SELECT 1
517: FROM MTL_UNITS_OF_MEASURE_TL
518: WHERE uom_code = p_uom_code
519: AND LANGUAGE = USERENV('LANG');
520:
521: cr_validate_uom cs_validate_uom%ROWTYPE;

Line 659: FROM MTL_UNITS_OF_MEASURE_TL

655:
656: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
657: is
658: SELECT 1
659: FROM MTL_UNITS_OF_MEASURE_TL
660: WHERE uom_code = p_uom_code
661: --AND uom_class = 'Time' commented for bug#5585356
662: AND LANGUAGE = USERENV('LANG');
663: cr_validate_uom cs_validate_uom%ROWTYPE;

Line 817: FROM MTL_UNITS_OF_MEASURE_TL

813: as
814: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
815: is
816: SELECT 1
817: FROM MTL_UNITS_OF_MEASURE_TL
818: WHERE uom_code = p_uom_code
819: --AND uom_class = 'Time' commented for bug#5585356
820: AND LANGUAGE = USERENV('LANG');
821:

Line 959: FROM MTL_UNITS_OF_MEASURE_TL

955:
956: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
957: is
958: SELECT 1
959: FROM MTL_UNITS_OF_MEASURE_TL
960: WHERE uom_code = p_uom_code
961: --AND uom_class = 'Time' commented for bug#5585356
962: AND LANGUAGE = USERENV('LANG');
963: cr_validate_uom cs_validate_uom%ROWTYPE;

Line 1114: FROM MTL_UNITS_OF_MEASURE_TL

1110:
1111: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
1112: is
1113: SELECT 1
1114: FROM MTL_UNITS_OF_MEASURE_TL
1115: WHERE uom_code = p_uom_code
1116: --AND uom_class = 'Time' commented for bug#5585356
1117: AND LANGUAGE = USERENV('LANG');
1118: