APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_RESOURCE_CLASSES_B

Line 58: FROM pa_resource_classes_b cls,

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

Line 233: FROM pa_resource_classes_b

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

Line 416: FROM pa_resource_classes_b

412: THEN
413: BEGIN
414: SELECT resource_class_id
415: INTO l_res_class_id
416: FROM pa_resource_classes_b
417: WHERE resource_class_code = l_res_class_code;
418: EXCEPTION
419: WHEN OTHERS THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 437: FROM pa_resource_classes_b

433: p_resource_class_code IS NOT NULL THEN
434: BEGIN
435: SELECT 'Y'
436: INTO l_res_class_valid
437: FROM pa_resource_classes_b
438: WHERE resource_class_code = p_resource_class_code
439: AND resource_class_id = p_resource_class_id;
440:
441: EXCEPTION