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_RESOURCE_ASSIGNMENTS

Line 221: from pa_resource_assignments where budget_version_id = p_budget_version_id;

217: -- bug 14040849 start
218: CURSOR get_res_asmts_cur IS
219: select resource_assignment_id, expenditure_type, non_labor_resource,
220: expenditure_category, event_type, incur_by_res_class_code, resource_class_code
221: from pa_resource_assignments where budget_version_id = p_budget_version_id;
222:
223: l_get_res_asmts_rec get_res_asmts_cur%ROWTYPE;
224:
225: l_expenditure_type_id NUMBER;

Line 295: FROM pa_resource_assignments ra

291: ,decode(ra.bom_resource_id,NULL,NULL,
292: decode(nvl(ra.incur_by_res_class_code,ra.resource_class_code),'EQUIPMENT',ra.bom_resource_id,NULL))
293: ,nvl(ra.incur_by_role_id,ra.project_role_id)
294: ,ra.person_type_code
295: FROM pa_resource_assignments ra
296: --,pa_budget_versions bv
297: --,pa_proj_fp_options fp
298: --,pa_expenditure_types et
299: --,pa_non_labor_resources nlr

Line 322: ,pa_resource_assignments ra

318: /* replaced the update stmt with the one below for bug 14040849
319: UPDATE pa_rbs_plans_in_tmp tmp
320: SET tmp.expenditure_type_id = (select et.expenditure_type_id
321: from pa_expenditure_types et
322: ,pa_resource_assignments ra
323: where et.expenditure_type = ra.expenditure_type
324: and ra.resource_assignment_id = tmp.source_id
325: and rownum =1 )
326: ,tmp.non_labor_resource_id = (select nlr.non_labor_resource_id

Line 328: ,pa_resource_assignments ra

324: and ra.resource_assignment_id = tmp.source_id
325: and rownum =1 )
326: ,tmp.non_labor_resource_id = (select nlr.non_labor_resource_id
327: from pa_non_labor_resources nlr
328: ,pa_resource_assignments ra
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

Line 334: ,pa_resource_assignments ra

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)
338: ,tmp.event_type_id = (select ev.event_type_id

Line 340: ,pa_resource_assignments ra

336: and ra.resource_assignment_id = tmp.source_id
337: and rownum = 1)
338: ,tmp.event_type_id = (select ev.event_type_id
339: from pa_event_types ev
340: ,pa_resource_assignments ra
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

Line 346: ,pa_resource_assignments ra

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) ;
350: End comment for bug 14040849*/

Line 861: FROM pa_resource_assignments ra

857: ,ra.project_id
858: ,ra.budget_version_id
859: ,l_financial_res_class_rlm_id
860: ,ra.cbs_element_id --bug#16827157
861: FROM pa_resource_assignments ra
862: WHERE ra.budget_version_id = p_budget_version_id;
863:
864: ELSE
865:

Line 953: FROM pa_resource_assignments ra

949: ,PLANNING_END_DATE
950: ,ra.project_id
951: ,ra.budget_version_id
952: ,ra.cbs_element_id --bug#16827157
953: FROM pa_resource_assignments ra
954: WHERE ra.budget_version_id = p_budget_version_id;
955:
956: END IF;
957:

Line 2911: from pa_resource_assignments ra

2907: CURSOR check_ResAsgn_Exists(p_budget_version_id Number) IS
2908: SELECT 'Y'
2909: FROM dual
2910: WHERE EXISTS (select null
2911: from pa_resource_assignments ra
2912: where ra.budget_version_id = p_budget_version_id);
2913:
2914: CURSOR rbs_name IS
2915: SELECT rbs1.name old_rbs_name

Line 3095: UPDATE pa_resource_assignments ra

3091: If l_txn_source_id_tab.count > 0 AND l_return_status = 'S' Then
3092: l_stage := 'Update Resource assignments with new RBS details';
3093: Print_msg(g_debug_flag,l_stage,l_proc_name);
3094: FORALL j IN l_txn_source_id_tab.FIRST ..l_txn_source_id_tab.LAST
3095: UPDATE pa_resource_assignments ra
3096: SET ra.rbs_element_id = NVL(l_rbs_element_id_tab(j),ra.rbs_element_id)
3097: ,ra.txn_accum_header_id = NVL(l_txn_accum_header_id_tab(j),ra.txn_accum_header_id)
3098: WHERE ra.budget_version_id = i.budget_version_id
3099: AND ra.project_id = i.project_id

Line 3213: UPDATE pa_resource_assignments ra

3209: If l_txn_source_id_tab.count > 0 AND l_return_status = 'S' Then
3210: l_stage := 'Update Resource assignments with new RBS details';
3211: Print_msg(g_debug_flag,l_stage,l_proc_name);
3212: FORALL j IN l_txn_source_id_tab.FIRST ..l_txn_source_id_tab.LAST
3213: UPDATE pa_resource_assignments ra
3214: SET ra.rbs_element_id = NVL(l_rbs_element_id_tab(j),ra.rbs_element_id)
3215: ,ra.txn_accum_header_id = NVL(l_txn_accum_header_id_tab(j),ra.txn_accum_header_id)
3216: WHERE ra.budget_version_id = i.budget_version_id
3217: AND ra.project_id = i.project_id