APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_RESOURCE_CLASSES_B

Line 302: --,pa_resource_classes_b rc

298: --,pa_expenditure_types et
299: --,pa_non_labor_resources nlr
300: --,pa_expenditure_categories ec
301: --,pa_event_types ev
302: --,pa_resource_classes_b rc
303: WHERE ra.budget_version_id = p_budget_version_id
304: --AND ra.budget_version_id = bv.budget_version_id (+)
305: --ANd bv.budget_version_id = fp.fin_plan_version_id(+)
306: --and ra.expenditure_type = et.expenditure_type (+)

Line 345: from pa_resource_classes_b rc

341: where ra.event_type = ev.event_type
342: and ra.resource_assignment_id = tmp.source_id
343: and rownum = 1)
344: ,tmp.resource_class_id = (select rc.resource_class_id
345: from pa_resource_classes_b rc
346: ,pa_resource_assignments ra
347: where nvl(ra.incur_by_res_class_code,ra.resource_class_code) = rc.resource_class_code
348: and ra.resource_assignment_id = tmp.source_id
349: and rownum = 1) ;

Line 372: FROM PA_RESOURCE_CLASSES_B RC

368: END IF;
369:
370: IF (l_get_res_asmts_rec.incur_by_res_class_code IS NOT NULL) OR (l_get_res_asmts_rec.resource_class_code) IS NOT NULL THEN
371: SELECT RC.RESOURCE_CLASS_ID into l_RESOURCE_CLASS_ID
372: FROM PA_RESOURCE_CLASSES_B RC
373: WHERE RC.RESOURCE_CLASS_CODE = NVL(l_get_res_asmts_rec.incur_by_res_class_code,l_get_res_asmts_rec.resource_class_code)
374: and rownum = 1;
375: END IF;
376:

Line 433: from pa_resource_classes_b rc

429: l_RESOURCE_CLASS_ID_TBL.extend(g_resource_class_code_sqltab.count);
430: For i in g_resource_class_code_sqltab.FIRST .. g_resource_class_code_sqltab.LAST LOOP
431: IF g_resource_class_code_sqltab(i) IS NOT NULL THEN
432: select rc.resource_class_id into l_RESOURCE_CLASS_ID_TBL(i)
433: from pa_resource_classes_b rc
434: where rc.resource_class_code = g_resource_class_code_sqltab(i)
435: and rownum = 1;
436: ELSE
437: l_RESOURCE_CLASS_ID_TBL(i) := NULL;

Line 553: from pa_resource_classes_b rc

549: l_RESOURCE_CLASS_ID_TBL.extend(g_resource_class_code_systab.count);
550: For i in g_resource_class_code_systab.FIRST .. g_resource_class_code_systab.LAST LOOP
551: IF g_resource_class_code_systab(i) IS NOT NULL THEN
552: select rc.resource_class_id into l_RESOURCE_CLASS_ID_TBL(i)
553: from pa_resource_classes_b rc
554: where rc.resource_class_code = g_resource_class_code_systab(i)
555: and rownum = 1;
556: ELSE
557: l_RESOURCE_CLASS_ID_TBL(i) := NULL;

Line 680: FROM PA_RESOURCE_CLASSES_B classes

676:
677: -- update the default item category
678: UPDATE pa_rbs_plans_in_tmp tmp
679: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
680: FROM PA_RESOURCE_CLASSES_B classes
681: ,PA_PLAN_RES_DEFAULTS cls
682: ,MTL_ITEM_CATEGORIES cat
683: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
684: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID

Line 1375: from pa_resource_classes_b rc

1371: /* update the resource class id for the inseted rows*/
1372: --FORALL i IN g_txn_id_sqltab.FIRST .. g_txn_id_sqltab.LAST
1373: UPDATE pa_res_list_map_tmp1 tmp
1374: SET tmp.resource_class_id = (select rc.resource_class_id
1375: from pa_resource_classes_b rc
1376: where rc.resource_class_code = tmp.resource_class_code)
1377: WHERE tmp.resource_class_code is NOT NULL
1378: ;
1379:

Line 1414: FROM PA_RESOURCE_CLASSES_B classes

1410:
1411: -- update default item category id if the resource is a inventory item
1412: UPDATE pa_res_list_map_tmp1 tmp
1413: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
1414: FROM PA_RESOURCE_CLASSES_B classes
1415: ,PA_PLAN_RES_DEFAULTS cls
1416: ,MTL_ITEM_CATEGORIES cat
1417: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
1418: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID