APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_RESOURCE_CLASSES_B

Line 60: FROM pa_resource_classes_b cls,

56: BEGIN
57:
58: SELECT def.item_master_id
59: INTO l_master_organization_id
60: FROM pa_resource_classes_b cls,
61: pa_plan_res_defaults def
62: WHERE cls.resource_class_code = 'MATERIAL_ITEMS'
63: AND cls.resource_class_id = def.resource_class_id
64: AND def.object_type = 'CLASS';

Line 236: FROM pa_resource_classes_b

232: * Cursor Declaration Section
233: ********************************/
234: Cursor get_class_details IS
235: SELECT resource_class_code
236: FROM pa_resource_classes_b
237: WHERE resource_class_id = p_resource_class_id;
238: Cursor get_fmt_details IS
239: SELECT res_type_id,res_type_enabled_flag,
240: resource_class_flag

Line 438: FROM pa_resource_classes_b

434: THEN
435: BEGIN
436: SELECT resource_class_id
437: INTO l_res_class_id
438: FROM pa_resource_classes_b
439: WHERE resource_class_code = l_res_class_code;
440: EXCEPTION
441: WHEN OTHERS THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 464: FROM pa_resource_classes_b

460: p_resource_class_code IS NOT NULL THEN
461: BEGIN
462: SELECT 'Y'
463: INTO l_res_class_valid
464: FROM pa_resource_classes_b
465: WHERE resource_class_code = p_resource_class_code
466: AND resource_class_id = p_resource_class_id;
467:
468: EXCEPTION