eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_EXPENDITURE_CATEGORIES

Line 266: --,pa_expenditure_categories ec

262: --,pa_budget_versions bv
263: --,pa_proj_fp_options fp
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 (+)

Line 298: from pa_expenditure_categories ec

294: where nlr.non_labor_resource = ra.non_labor_resource
295: and ra.resource_assignment_id = tmp.source_id
296: and rownum = 1)
297: ,tmp.expenditure_category_id = (select ec.expenditure_category_id
298: from pa_expenditure_categories ec
299: ,pa_resource_assignments ra
300: where ec.expenditure_category = ra.expenditure_category
301: and ra.resource_assignment_id = tmp.source_id
302: and rownum = 1)

Line 377: from pa_expenditure_categories ec

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))
379: /* Bug fix: 3999186 populating event type */
380: ,tmp.event_type_id = (select evt.event_type_id
381: from pa_event_types evt

Line 444: from pa_expenditure_categories ec

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))
446: /* Bug fix: 3999186 populating event type */
447: ,event_type_id = (select evt.event_type_id
448: from pa_event_types evt

Line 458: ,pa_expenditure_categories etc

454: -- update exp category id if null
455: UPDATE pa_rbs_plans_in_tmp tmp
456: SET tmp.expenditure_category_id = (select etc.expenditure_category_id
457: from pa_expenditure_types et
458: ,pa_expenditure_categories etc
459: where et.expenditure_type_id = tmp.expenditure_type_id
460: and et.expenditure_category = etc.expenditure_category
461: )
462: WHERE tmp.expenditure_category_id is NULL

Line 1173: ,pa_expenditure_categories etc

1169: -- update exp category id if null
1170: UPDATE pa_res_list_map_tmp1 tmp
1171: SET tmp.expenditure_category = (select etc.expenditure_category
1172: from pa_expenditure_types et
1173: ,pa_expenditure_categories etc
1174: where et.expenditure_type = tmp.expenditure_type
1175: and et.expenditure_category = etc.expenditure_category
1176: and rownum = 1
1177: )