APPS.MSC_GET_NAME dependencies on MSC_PROJECTS

Line 17: from msc_projects

13: return null;
14: ELSIF arg_org_id IS NULL THEN
15: select distinct project_number
16: into var_project_num
17: from msc_projects
18: where project_id = arg_project_id
19: and plan_id = -1
20: and sr_instance_id=arg_instance_id
21: and rownum = 1;

Line 25: from msc_projects

21: and rownum = 1;
22: ELSE
23: select project_number
24: into var_project_num
25: from msc_projects
26: where project_id = arg_project_id
27: and plan_id = -1
28: and sr_instance_id=arg_instance_id
29: and organization_id = arg_org_id;

Line 121: from msc_projects

117: END IF;
118:
119: select DISTINCT planning_group
120: into var_plng_grp
121: from msc_projects
122: where project_id = arg_project_id
123: and plan_id = -1
124: and sr_instance_id=arg_instance_id
125: and organization_id = arg_org_id;