DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_PLANNED_RESOURCES_V

Line 2669: from msc_planned_resources_v

2665: return null;
2666: elsif arg_resource_type = 100 then
2667: select resource_code
2668: into v_resource_code
2669: from msc_planned_resources_v
2670: where department_id = arg_dept_id
2671: and resource_id = arg_resource_id
2672: and plan_id = arg_plan_id
2673: and organization_id = arg_org_id

Line 2703: from msc_planned_resources_v

2699: return null;
2700: else
2701: select distinct resource_desc
2702: into v_resource_desc
2703: from msc_planned_resources_v
2704: where department_id = arg_dept_id
2705: and resource_id = arg_resource_id
2706: and plan_id = arg_plan_id
2707: and organization_id = arg_org_id