APPS.MSC_PQ_UTILS dependencies on MSC_APPS_INSTANCES

Line 2200: FROM msc_apps_instances

2196: CURSOR cur_release_flag(p_instance_id NUMBER) IS
2197: SELECT DECODE(apps_ver,3,NVL(allow_release_flag ,2),
2198: 4,NVL(allow_release_flag ,2),1) allow_release_flag,
2199: instance_code
2200: FROM msc_apps_instances
2201: WHERE instance_id = nvl(p_sr_instance_id,-1);
2202: BEGIN
2203: OPEN cur_release_flag(p_sr_instance_id);
2204: FETCH cur_release_flag into l_allow_release_flag,p_instance_code;