APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RESOURCE_CLASSES_B

Line 1700: -- , pa_resource_classes_b cl

1696: BEGIN
1697: SELECT def.item_category_set_id
1698: INTO l_item_category_set_id
1699: FROM pa_plan_res_defaults def
1700: -- , pa_resource_classes_b cl
1701: WHERE def.resource_class_id = 3
1702: AND def.object_type ='CLASS';
1703: --AND cl.resource_class_id = def.resource_class_id
1704: --AND cl.resource_class_id = 3;

Line 1742: -- , pa_resource_classes_b cl

1738: BEGIN
1739: SELECT def.item_master_id
1740: INTO l_item_master_id
1741: FROM pa_plan_res_defaults def
1742: -- , pa_resource_classes_b cl
1743: WHERE def.resource_class_id = 3
1744: AND def.object_type ='CLASS';
1745: --AND cl.resource_class_id = def.resource_class_id
1746: --AND cl.resource_class_id = 3;

Line 2066: FROM pa_resource_classes_b cls,

2062: WHERE items.inventory_item_id =
2063: res_temp.inventory_item_id
2064: AND items.organization_id =
2065: (SELECT def.item_master_id
2066: FROM pa_resource_classes_b cls,
2067: pa_plan_res_defaults def
2068: WHERE cls.resource_class_code = 'MATERIAL_ITEMS'
2069: AND cls.resource_class_id = def.resource_class_id
2070: AND def.object_type = 'CLASS')

Line 2305: FROM pa_resource_classes_b cls,

2301: FROM mtl_system_items_b i
2302: WHERE i.inventory_item_id = res_temp.inventory_item_id
2303: AND i.organization_id =
2304: (SELECT def.item_master_id
2305: FROM pa_resource_classes_b cls,
2306: pa_plan_res_defaults def
2307: WHERE cls.resource_class_code = 'MATERIAL_ITEMS'
2308: AND cls.resource_class_id = def.resource_class_id
2309: AND def.object_type = 'CLASS')

Line 3036: pa_resource_classes_b cls,

3032: and organization_id =
3033: (select
3034: item_master_id
3035: from
3036: pa_resource_classes_b cls,
3037: pa_plan_res_defaults def
3038: where
3039: def.resource_class_id = cls.resource_class_id
3040: and cls.resource_class_code = 'MATERIAL_ITEMS'

Line 3073: ,Pa_Resource_Classes_b c

3069: a.incurred_by_res_flag incurred_by_res_flag,
3070: c.Resource_Class_Id
3071: From
3072: Pa_Resource_Assignments a
3073: ,Pa_Resource_Classes_b c
3074: Where
3075: c.Resource_Class_Code = a.Resource_Class_Code
3076: And a.Resource_Assignment_Id = P_Res_Assignment_Id;
3077: