APPS.CSD_SERVICE_CODES_PVT dependencies on CSD_SERVICE_CODES_B

Line 111: from csd_service_codes_b

107: -- Validate the code for service code
108: Begin
109: select 'X'
110: into l_dummy
111: from csd_service_codes_b
112: where service_code = UPPER(p_service_code_rec.service_code);
113:
114: Exception
115:

Line 423: from csd_service_codes_b

419: -- Validate the id for service code
420: Begin
421: select 'X'
422: into l_dummy
423: from csd_service_codes_b
424: where service_code_id = p_service_code_rec.service_code_id;
425:
426: Exception
427:

Line 453: from csd_service_codes_b

449: -- Get object version number for service code
450: Begin
451: select object_version_number
452: into l_obj_ver_num
453: from csd_service_codes_b
454: where service_code_id = p_service_code_rec.service_code_id;
455:
456: Exception
457:

Line 491: from csd_service_codes_b

487: l_dummy := null;
488:
489: select 'X'
490: into l_dummy
491: from csd_service_codes_b
492: where service_code = UPPER(p_service_code_rec.service_code)
493: and service_code_id <> p_service_code_rec.service_code_id;
494:
495: Exception