APPS.MSC_GET_NAME dependencies on MSC_PROJECTS

Line 31: from msc_projects

27:
28: IF arg_org_id IS NULL THEN
29: select distinct project_number
30: into var_project_num
31: from msc_projects
32: where project_id = arg_project_id
33: and plan_id = -1
34: and sr_instance_id=arg_instance_id
35: and rownum = 1;

Line 39: from msc_projects

35: and rownum = 1;
36: ELSE
37: select project_number
38: into var_project_num
39: from msc_projects
40: where project_id = arg_project_id
41: and plan_id = -1
42: and sr_instance_id=arg_instance_id
43: and organization_id = arg_org_id;

Line 199: from msc_projects

195: END IF;
196:
197: select DISTINCT planning_group
198: into var_plng_grp
199: from msc_projects
200: where project_id = arg_project_id
201: and plan_id = -1
202: and sr_instance_id=arg_instance_id
203: and organization_id = arg_org_id;