APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RESOURCE_CLASSES_B

Line 1687: -- , pa_resource_classes_b cl

1683: BEGIN
1684: SELECT def.item_category_set_id
1685: INTO l_item_category_set_id
1686: FROM pa_plan_res_defaults def
1687: -- , pa_resource_classes_b cl
1688: WHERE def.resource_class_id = 3
1689: AND def.object_type ='CLASS';
1690: --AND cl.resource_class_id = def.resource_class_id
1691: --AND cl.resource_class_id = 3;

Line 1729: -- , pa_resource_classes_b cl

1725: BEGIN
1726: SELECT def.item_master_id
1727: INTO l_item_master_id
1728: FROM pa_plan_res_defaults def
1729: -- , pa_resource_classes_b cl
1730: WHERE def.resource_class_id = 3
1731: AND def.object_type ='CLASS';
1732: --AND cl.resource_class_id = def.resource_class_id
1733: --AND cl.resource_class_id = 3;

Line 2026: FROM pa_resource_classes_b cls,

2022: WHERE items.inventory_item_id =
2023: res_temp.inventory_item_id
2024: AND items.organization_id =
2025: (SELECT def.item_master_id
2026: FROM pa_resource_classes_b cls,
2027: pa_plan_res_defaults def
2028: WHERE cls.resource_class_code = 'MATERIAL_ITEMS'
2029: AND cls.resource_class_id = def.resource_class_id
2030: AND def.object_type = 'CLASS')

Line 2265: FROM pa_resource_classes_b cls,

2261: FROM mtl_system_items_b i
2262: WHERE i.inventory_item_id = res_temp.inventory_item_id
2263: AND i.organization_id =
2264: (SELECT def.item_master_id
2265: FROM pa_resource_classes_b cls,
2266: pa_plan_res_defaults def
2267: WHERE cls.resource_class_code = 'MATERIAL_ITEMS'
2268: AND cls.resource_class_id = def.resource_class_id
2269: AND def.object_type = 'CLASS')

Line 2995: pa_resource_classes_b cls,

2991: and organization_id =
2992: (select
2993: item_master_id
2994: from
2995: pa_resource_classes_b cls,
2996: pa_plan_res_defaults def
2997: where
2998: def.resource_class_id = cls.resource_class_id
2999: and cls.resource_class_code = 'MATERIAL_ITEMS'

Line 3032: ,Pa_Resource_Classes_b c

3028: a.incurred_by_res_flag incurred_by_res_flag,
3029: c.Resource_Class_Id
3030: From
3031: Pa_Resource_Assignments a
3032: ,Pa_Resource_Classes_b c
3033: Where
3034: c.Resource_Class_Code = a.Resource_Class_Code
3035: And a.Resource_Assignment_Id = P_Res_Assignment_Id;
3036: