DBA Data[Home] [Help]

APPS.OKC_TCU_PVT dependencies on OKC_TIMEUNIT_V

Line 488: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS

484: */
485: /*
486: --Commented this cursor as this cursor should be based on MTL_UNITS_OF_MEASURE
487:
488: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS
489: SELECT '1'
490: FROM okc_timeunit_v
491: WHERE uom_code = p_uom_code
492: AND active_flag = 'Y';

Line 490: FROM okc_timeunit_v

486: --Commented this cursor as this cursor should be based on MTL_UNITS_OF_MEASURE
487:
488: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS
489: SELECT '1'
490: FROM okc_timeunit_v
491: WHERE uom_code = p_uom_code
492: AND active_flag = 'Y';
493: */
494: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS

Line 494: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS

490: FROM okc_timeunit_v
491: WHERE uom_code = p_uom_code
492: AND active_flag = 'Y';
493: */
494: CURSOR uom_pk_csr (p_uom_code IN okc_timeunit_v.uom_code%type) IS
495: SELECT '1'
496: FROM OKX_Units_Of_Measure_v
497: WHERE uom_code = p_uom_code
498: AND (trunc(disable_date) > trunc(sysdate) or