DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_PLANNED_RESOURCES_V

Line 3071: from msc_planned_resources_v

3067: return null;
3068: elsif arg_resource_type = 100 then
3069: select resource_code
3070: into v_resource_code
3071: from msc_planned_resources_v
3072: where department_id = arg_dept_id
3073: and resource_id = arg_resource_id
3074: and plan_id = arg_plan_id
3075: and organization_id = arg_org_id

Line 3105: from msc_planned_resources_v

3101: return null;
3102: else
3103: select distinct resource_desc
3104: into v_resource_desc
3105: from msc_planned_resources_v
3106: where department_id = arg_dept_id
3107: and resource_id = arg_resource_id
3108: and plan_id = arg_plan_id
3109: and organization_id = arg_org_id