4453: CURSOR chk_service_type_code
4454: IS
4455: SELECT
4456: COUNT(lookup_code) 4457: FROM ja_lookups 4458: WHERE lookup_type = 'JAI_SERVICE_TYPE'
4459: AND lookup_code = pv_service_type_code;
4460:
4461: --Added by zhiwei for Bug#12584814 on 20110607 begin