APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_RESOURCE_CLASSES_B

Line 268: --,pa_resource_classes_b rc

264: --,pa_expenditure_types et
265: --,pa_non_labor_resources nlr
266: --,pa_expenditure_categories ec
267: --,pa_event_types ev
268: --,pa_resource_classes_b rc
269: WHERE ra.budget_version_id = p_budget_version_id
270: --AND ra.budget_version_id = bv.budget_version_id (+)
271: --ANd bv.budget_version_id = fp.fin_plan_version_id(+)
272: --and ra.expenditure_type = et.expenditure_type (+)

Line 310: from pa_resource_classes_b rc

306: where ra.event_type = ev.event_type
307: and ra.resource_assignment_id = tmp.source_id
308: and rownum = 1)
309: ,tmp.resource_class_id = (select rc.resource_class_id
310: from pa_resource_classes_b rc
311: ,pa_resource_assignments ra
312: where nvl(ra.incur_by_res_class_code,ra.resource_class_code) = rc.resource_class_code
313: and ra.resource_assignment_id = tmp.source_id
314: and rownum = 1) ;

Line 374: from pa_resource_classes_b rc

370: , tmp.non_labor_resource_id = (select nlr.non_labor_resource_id
371: from pa_non_labor_resources nlr
372: where nlr.non_labor_resource = g_non_labor_resource_sqltab(i))
373: ,tmp.resource_class_id = (select rc.resource_class_id
374: from pa_resource_classes_b rc
375: where rc.resource_class_code = g_resource_class_code_sqltab(i) )
376: ,tmp.expenditure_category_id = (select ec.expenditure_category_id
377: from pa_expenditure_categories ec
378: where ec.expenditure_category = g_expenditure_category_sqltab(i))

Line 441: from pa_resource_classes_b rc

437: , non_labor_resource_id = (select nlr.non_labor_resource_id
438: from pa_non_labor_resources nlr
439: where nlr.non_labor_resource = g_non_labor_resource_systab(i))
440: ,resource_class_id = (select rc.resource_class_id
441: from pa_resource_classes_b rc
442: where rc.resource_class_code = g_resource_class_code_systab(i) )
443: ,expenditure_category_id = (select ec.expenditure_category_id
444: from pa_expenditure_categories ec
445: where ec.expenditure_category = g_expenditure_category_systab(i))

Line 489: FROM PA_RESOURCE_CLASSES_B classes

485:
486: -- update the default item category
487: UPDATE pa_rbs_plans_in_tmp tmp
488: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
489: FROM PA_RESOURCE_CLASSES_B classes
490: ,PA_PLAN_RES_DEFAULTS cls
491: ,MTL_ITEM_CATEGORIES cat
492: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
493: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID

Line 1163: from pa_resource_classes_b rc

1159: /* update the resource class id for the inseted rows*/
1160: --FORALL i IN g_txn_id_sqltab.FIRST .. g_txn_id_sqltab.LAST
1161: UPDATE pa_res_list_map_tmp1 tmp
1162: SET tmp.resource_class_id = (select rc.resource_class_id
1163: from pa_resource_classes_b rc
1164: where rc.resource_class_code = tmp.resource_class_code)
1165: WHERE tmp.resource_class_code is NOT NULL
1166: ;
1167:

Line 1202: FROM PA_RESOURCE_CLASSES_B classes

1198:
1199: -- update default item category id if the resource is a inventory item
1200: UPDATE pa_res_list_map_tmp1 tmp
1201: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
1202: FROM PA_RESOURCE_CLASSES_B classes
1203: ,PA_PLAN_RES_DEFAULTS cls
1204: ,MTL_ITEM_CATEGORIES cat
1205: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
1206: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID