APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_EXPENDITURE_TYPES

Line 298: --,pa_expenditure_types et

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
300: --,pa_expenditure_categories ec
301: --,pa_event_types ev
302: --,pa_resource_classes_b rc

Line 321: from pa_expenditure_types et

317: l_stage := 'Update the tmp table with exp,event,cate,Ids';
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 )

Line 362: FROM PA_EXPENDITURE_TYPES ET WHERE ET.EXPENDITURE_TYPE = l_get_res_asmts_rec.expenditure_type;

358: l_EVENT_TYPE_ID := NULL;
359:
360: IF l_get_res_asmts_rec.expenditure_type IS NOT NULL THEN
361: SELECT ET.EXPENDITURE_TYPE_ID into l_EXPENDITURE_TYPE_ID
362: FROM PA_EXPENDITURE_TYPES ET WHERE ET.EXPENDITURE_TYPE = l_get_res_asmts_rec.expenditure_type;
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

Line 409: from pa_expenditure_types et

405: l_EXPENDITURE_TYPE_ID_TBL.extend(g_expenditure_type_sqltab.count);
406: For i in g_expenditure_type_sqltab.FIRST .. g_expenditure_type_sqltab.LAST LOOP
407: IF g_expenditure_type_sqltab(i) IS NOT NULL THEN
408: select et.expenditure_type_id INTO l_EXPENDITURE_TYPE_ID_TBL(i)
409: from pa_expenditure_types et
410: where et.expenditure_type = g_expenditure_type_sqltab(i)
411: and rownum = 1;
412: ELSE
413: l_EXPENDITURE_TYPE_ID_TBL(i) := NULL;

Line 529: from pa_expenditure_types et

525: l_EXPENDITURE_TYPE_ID_TBL.extend(g_expenditure_type_systab.count);
526: For i in g_expenditure_type_systab.FIRST .. g_expenditure_type_systab.LAST LOOP
527: IF g_expenditure_type_systab(i) IS NOT NULL THEN
528: select et.expenditure_type_id INTO l_EXPENDITURE_TYPE_ID_TBL(i)
529: from pa_expenditure_types et
530: where et.expenditure_type = g_expenditure_type_systab(i)
531: and rownum = 1;
532: ELSE
533: l_EXPENDITURE_TYPE_ID_TBL(i) := NULL;

Line 648: from pa_expenditure_types et

644: /* Bug fix: 3698579 */
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: )

Line 671: from pa_expenditure_types et

667:
668: -- update revenue category if its null based on expendiure types
669: UPDATE pa_rbs_plans_in_tmp tmp
670: SET tmp.Revenue_category_code = (select et.Revenue_category_code
671: from pa_expenditure_types et
672: where et.expenditure_type_id = tmp.expenditure_type_id
673: )
674: WHERE tmp.Revenue_category_code is NULL
675: AND tmp.expenditure_type_id is NOT NULL ;

Line 1384: from pa_expenditure_types et

1380: /* Bug fix: 3698579 */
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

Line 1404: from pa_expenditure_types et

1400:
1401: -- update revenue category based on exp type if its null
1402: UPDATE pa_res_list_map_tmp1 tmp
1403: SET tmp.Revenue_category = (select et.Revenue_category_code
1404: from pa_expenditure_types et
1405: where et.expenditure_type = tmp.expenditure_type
1406: and rownum = 1
1407: )
1408: WHERE tmp.Revenue_category is NULL