445:
446:
447: CURSOR c_site_ref_id (l_site_ref_code IN VARCHAR2) IS
448: SELECT site_id
449: FROM ams_iba_pl_sites_b
450: WHERE site_ref_code = l_site_ref_code;
451:
452: CURSOR c_site_id_exists (l_site_id IN NUMBER) IS
453: SELECT site_id
450: WHERE site_ref_code = l_site_ref_code;
451:
452: CURSOR c_site_id_exists (l_site_id IN NUMBER) IS
453: SELECT site_id
454: FROM ams_iba_pl_sites_b
455: WHERE site_id = l_site_id;
456:
457:
458: CURSOR c_pctype_id_exists (l_id IN NUMBER) IS