APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_NON_LABOR_RESOURCES

Line 299: --,pa_non_labor_resources nlr

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
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

Line 327: from pa_non_labor_resources nlr

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
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)

Line 367: FROM PA_NON_LABOR_RESOURCES NLR WHERE NLR.NON_LABOR_RESOURCE = l_get_res_asmts_rec.non_labor_resource;

363: END IF;
364:
365: IF l_get_res_asmts_rec.non_labor_resource IS NOT NULL THEN
366: SELECT NLR.NON_LABOR_RESOURCE_ID into l_NON_LABOR_RESOURCE_ID
367: FROM PA_NON_LABOR_RESOURCES NLR WHERE NLR.NON_LABOR_RESOURCE = l_get_res_asmts_rec.non_labor_resource;
368: END IF;
369:
370: IF (l_get_res_asmts_rec.incur_by_res_class_code IS NOT NULL) OR (l_get_res_asmts_rec.resource_class_code) IS NOT NULL THEN
371: SELECT RC.RESOURCE_CLASS_ID into l_RESOURCE_CLASS_ID

Line 421: from pa_non_labor_resources nlr

417: l_NON_LABOR_RESOURCE_ID_TBL.extend(g_non_labor_resource_sqltab.count);
418: For i in g_non_labor_resource_sqltab.FIRST .. g_non_labor_resource_sqltab.LAST LOOP
419: IF g_non_labor_resource_sqltab(i) IS NOT NULL THEN
420: select nlr.non_labor_resource_id INTO l_NON_LABOR_RESOURCE_ID_TBL(i)
421: from pa_non_labor_resources nlr
422: where nlr.non_labor_resource = g_non_labor_resource_sqltab(i)
423: and rownum = 1;
424: ELSE
425: l_NON_LABOR_RESOURCE_ID_TBL(i) := NULL;

Line 541: from pa_non_labor_resources nlr

537: l_NON_LABOR_RESOURCE_ID_TBL.extend(g_non_labor_resource_systab.count);
538: For i in g_non_labor_resource_systab.FIRST .. g_non_labor_resource_systab.LAST LOOP
539: IF g_non_labor_resource_systab(i) IS NOT NULL THEN
540: select nlr.non_labor_resource_id INTO l_NON_LABOR_RESOURCE_ID_TBL(i)
541: from pa_non_labor_resources nlr
542: where nlr.non_labor_resource = g_non_labor_resource_systab(i)
543: and rownum = 1;
544: ELSE
545: l_NON_LABOR_RESOURCE_ID_TBL(i) := NULL;