DBA Data[Home] [Help]

APPS.AMS_WEBMARKETING_PVT dependencies on AMS_IBA_PL_SITES_B

Line 449: FROM ams_iba_pl_sites_b

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

Line 454: 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
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