APPS.ODP dependencies on MSD_DEMAND_PLANS_V

Line 14: v_mod_shared_path MSD_DEMAND_PLANS_V.SHARED_DB_LOCATION%TYPE;

10: v_language varchar2(240);
11: v_url varchar2(2000);
12: n_web_user number;
13: b_plans_found boolean;
14: v_mod_shared_path MSD_DEMAND_PLANS_V.SHARED_DB_LOCATION%TYPE;
15: v_odp_resp varchar2(2) NOT NULL := 'NA';
16: v_browser varchar2(80);
17: v_prompt_tab icx_util.g_prompts_table;
18: v_title varchar2(80);

Line 46: from msd_demand_plans_v

42: cursor c_demand_plans is
43: select DEMAND_PLAN_ID, DEMAND_PLAN_NAME,
44: EXPRESS_MACHINE_PORT, OWA_VIRTUAL_PATH_NAME,
45: EAD_NAME, SHARED_DB_LOCATION, SHARED_DB_PREFIX
46: from msd_demand_plans_v
47: where demand_plan_id in
48: (select demand_plan_id from msd_dp_users_v
49: where user_id = n_web_user and
50: responsibility_id = n_responsibility_id)