DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_PROJECT_TASKS

Line 49: from msc_project_tasks

45: return null;
46: ELSIF (arg_org_id is null or arg_project_id is null) THEN
47: select distinct task_number
48: into var_task_num
49: from msc_project_tasks
50: where task_id = arg_task_id
51: and plan_id = -1
52: and sr_instance_id=arg_instance_id
53: and rownum = 1;

Line 57: from msc_project_tasks

53: and rownum = 1;
54: ELSE
55: select task_number
56: into var_task_num
57: from msc_project_tasks
58: where project_id = arg_project_id
59: and task_id = arg_task_id
60: and plan_id = -1
61: and sr_instance_id=arg_instance_id