APPS.AMS_WEBMARKETING_PVT dependencies on AMS_WEB_PLACEMENTS_B
Line 443: FROM AMS_WEB_PLACEMENTS_B
439:
440:
441: CURSOR c_p_id_exists (l_id IN NUMBER) IS
442: SELECT 1 443: FROM AMS_WEB_PLACEMENTS_B 444: WHERE PLACEMENT_ID = l_id;
445:
446:
447: CURSOR c_site_ref_id (l_site_ref_code IN VARCHAR2) IS
Line 643: select auto_publish_flag from ams_web_placements_b where placement_id = p_placement_id;
639: )
640: RETURN VARCHAR
641: IS
642: CURSOR c_check_placement_publish IS 643: select auto_publish_flag from ams_web_placements_b where placement_id = p_placement_id; 644: l_publish VARCHAR2(1);
645:
646: BEGIN
647: