APPS.MSC_PQ_UTILS dependencies on MSC_APPS_INSTANCES

Line 2150: FROM msc_apps_instances

2146: CURSOR cur_release_flag(p_instance_id NUMBER) IS
2147: SELECT DECODE(apps_ver,3,NVL(allow_release_flag ,2),
2148: 4,NVL(allow_release_flag ,2),1) allow_release_flag,
2149: instance_code
2150: FROM msc_apps_instances
2151: WHERE instance_id = nvl(p_sr_instance_id,-1);
2152: BEGIN
2153: OPEN cur_release_flag(p_sr_instance_id);
2154: FETCH cur_release_flag into l_allow_release_flag,p_instance_code;