APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_EVENT_TYPES

Line 301: --,pa_event_types ev

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 (+)
305: --ANd bv.budget_version_id = fp.fin_plan_version_id(+)

Line 339: from pa_event_types ev

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

Line 384: FROM PA_EVENT_TYPES EVT WHERE EVT.EVENT_TYPE = l_get_res_asmts_rec.event_type;

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
384: FROM PA_EVENT_TYPES EVT WHERE EVT.EVENT_TYPE = l_get_res_asmts_rec.event_type;
385: END IF;
386:
387: UPDATE PA_RBS_PLANS_IN_TMP
388: SET EXPENDITURE_TYPE_ID = l_EXPENDITURE_TYPE_ID,

Line 457: from pa_event_types evt

453: l_EVENT_TYPE_ID_TBL.extend(g_event_type_sqltab.count);
454: For i in g_event_type_sqltab.FIRST .. g_event_type_sqltab.LAST LOOP
455: IF g_event_type_sqltab(i) IS NOT NULL THEN
456: select evt.event_type_id into l_EVENT_TYPE_ID_TBL(i)
457: from pa_event_types evt
458: where evt.event_type = g_event_type_sqltab(i)
459: and rownum = 1;
460: ELSE
461: l_EVENT_TYPE_ID_TBL(i) := NULL;

Line 577: from pa_event_types evt

573: l_EVENT_TYPE_ID_TBL.extend(g_event_type_systab.count);
574: For i in g_event_type_systab.FIRST .. g_event_type_systab.LAST LOOP
575: IF g_event_type_systab(i) IS NOT NULL THEN
576: select evt.event_type_id into l_EVENT_TYPE_ID_TBL(i)
577: from pa_event_types evt
578: where evt.event_type = g_event_type_systab(i)
579: and rownum = 1;
580: ELSE
581: l_EVENT_TYPE_ID_TBL(i) := NULL;

Line 661: from pa_event_types et

657: /* Bug fix: 3999186 populate revenue category based on event types */
658: -- update revenue category if its null based on event types
659: UPDATE pa_rbs_plans_in_tmp tmp
660: SET tmp.Revenue_category_code = (select et.Revenue_category_code
661: from pa_event_types et
662: where et.event_type_id = tmp.event_type_id
663: )
664: WHERE tmp.Revenue_category_code is NULL
665: AND tmp.event_type_id is NOT NULL ;

Line 1396: FROM pa_event_types evt

1392:
1393: -- update revenue category based on event type if its null
1394: UPDATE pa_res_list_map_tmp1 tmp
1395: SET tmp.revenue_category = (SELECT evt.revenue_category_code
1396: FROM pa_event_types evt
1397: WHERE evt.event_type=tmp.event_type)
1398: WHERE tmp.revenue_category IS NULL
1399: AND tmp.event_type IS NOT NULL;
1400: