APPS.PA_RESOURCE_UTILS1 dependencies on PA_PLAN_RES_DEFAULTS

Line 10: x_material_class_id OUT NOCOPY PA_PLAN_RES_DEFAULTS.item_master_id%TYPE, --File.Sql.39 bug 4440895

6: =============================================================================*/
7:
8:
9: PROCEDURE Return_Material_Class_Id(
10: x_material_class_id OUT NOCOPY PA_PLAN_RES_DEFAULTS.item_master_id%TYPE, --File.Sql.39 bug 4440895
11: x_return_status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
12: x_msg_data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
13: x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
14: )

Line 23: from PA_PLAN_RES_DEFAULTS

19: x_msg_data:=null;
20: x_msg_count:=null;
21:
22: select item_master_id into x_material_class_id
23: from PA_PLAN_RES_DEFAULTS
24: where resource_class_id=3;
25:
26:
27: EXCEPTION