DBA Data[Home] [Help]

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: