APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_NON_LABOR_RESOURCES

Line 265: --,pa_non_labor_resources nlr

261: FROM pa_resource_assignments ra
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

Line 292: from pa_non_labor_resources nlr

288: where et.expenditure_type = ra.expenditure_type
289: and ra.resource_assignment_id = tmp.source_id
290: and rownum =1 )
291: ,tmp.non_labor_resource_id = (select nlr.non_labor_resource_id
292: from pa_non_labor_resources nlr
293: ,pa_resource_assignments ra
294: where nlr.non_labor_resource = ra.non_labor_resource
295: and ra.resource_assignment_id = tmp.source_id
296: and rownum = 1)

Line 371: from pa_non_labor_resources nlr

367: SET tmp.expenditure_type_id = (select et.expenditure_type_id
368: from pa_expenditure_types et
369: where et.expenditure_type = g_expenditure_type_sqltab(i))
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) )

Line 438: from pa_non_labor_resources nlr

434: SET expenditure_type_id = (select et.expenditure_type_id
435: from pa_expenditure_types et
436: where et.expenditure_type = g_expenditure_type_systab(i))
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) )