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 300: --,pa_expenditure_categories ec

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

Line 333: from pa_expenditure_categories ec

329: where nlr.non_labor_resource = ra.non_labor_resource
330: and ra.resource_assignment_id = tmp.source_id
331: and rownum = 1)
332: ,tmp.expenditure_category_id = (select ec.expenditure_category_id
333: from pa_expenditure_categories ec
334: ,pa_resource_assignments ra
335: where ec.expenditure_category = ra.expenditure_category
336: and ra.resource_assignment_id = tmp.source_id
337: and rownum = 1)

Line 379: FROM PA_EXPENDITURE_CATEGORIES EC WHERE EC.EXPENDITURE_CATEGORY = l_get_res_asmts_rec.expenditure_category;

375: END IF;
376:
377: IF l_get_res_asmts_rec.expenditure_category IS NOT NULL THEN
378: SELECT EC.EXPENDITURE_CATEGORY_ID into l_EXPENDITURE_CATEGORY_ID
379: FROM PA_EXPENDITURE_CATEGORIES EC WHERE EC.EXPENDITURE_CATEGORY = l_get_res_asmts_rec.expenditure_category;
380: END IF;
381:
382: IF l_get_res_asmts_rec.event_type IS NOT NULL THEN
383: SELECT EVT.EVENT_TYPE_ID into l_EVENT_TYPE_ID

Line 445: from pa_expenditure_categories ec

441: L_expenditure_category_id_TBL.extend(g_expenditure_category_sqltab.count);
442: For i in g_expenditure_category_sqltab.FIRST .. g_expenditure_category_sqltab.LAST LOOP
443: IF g_expenditure_category_sqltab(i) IS NOT NULL THEN
444: select ec.expenditure_category_id into L_expenditure_category_id_TBL(i)
445: from pa_expenditure_categories ec
446: where ec.expenditure_category = g_expenditure_category_sqltab(i)
447: and rownum = 1;
448: ELSE
449: L_expenditure_category_id_TBL(i) := NULL;

Line 565: from pa_expenditure_categories ec

561: L_expenditure_category_id_TBL.extend(g_expenditure_category_systab.count);
562: For i in g_expenditure_category_systab.FIRST .. g_expenditure_category_systab.LAST LOOP
563: IF g_expenditure_category_systab(i) IS NOT NULL THEN
564: select ec.expenditure_category_id into L_expenditure_category_id_TBL(i)
565: from pa_expenditure_categories ec
566: where ec.expenditure_category = g_expenditure_category_systab(i)
567: and rownum = 1;
568: ELSE
569: L_expenditure_category_id_TBL(i) := NULL;

Line 649: ,pa_expenditure_categories etc

645: -- update exp category id if null
646: UPDATE pa_rbs_plans_in_tmp tmp
647: SET tmp.expenditure_category_id = (select etc.expenditure_category_id
648: from pa_expenditure_types et
649: ,pa_expenditure_categories etc
650: where et.expenditure_type_id = tmp.expenditure_type_id
651: and et.expenditure_category = etc.expenditure_category
652: )
653: WHERE tmp.expenditure_category_id is NULL

Line 1385: ,pa_expenditure_categories etc

1381: -- update exp category id if null
1382: UPDATE pa_res_list_map_tmp1 tmp
1383: SET tmp.expenditure_category = (select etc.expenditure_category
1384: from pa_expenditure_types et
1385: ,pa_expenditure_categories etc
1386: where et.expenditure_type = tmp.expenditure_type
1387: and et.expenditure_category = etc.expenditure_category
1388: and rownum = 1
1389: )