DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_PROJECT_TASKS

Line 82: from msc_project_tasks

78:
79: IF (arg_org_id is null or arg_project_id is null) THEN
80: select distinct task_number
81: into var_task_num
82: from msc_project_tasks
83: where task_id = arg_task_id
84: and plan_id = -1
85: and sr_instance_id=arg_instance_id
86: and rownum = 1;

Line 90: from msc_project_tasks

86: and rownum = 1;
87: ELSE
88: select task_number
89: into var_task_num
90: from msc_project_tasks
91: where project_id = arg_project_id
92: and task_id = arg_task_id
93: and plan_id = -1
94: and sr_instance_id=arg_instance_id