APPS.PA_RESOURCE_MAPPING dependencies on PA_EVENT_TYPES

Line 1176: FROM pa_event_types evt

1172: /* Added for bug 3653120 */
1173:
1174: UPDATE pa_res_list_map_tmp1 tmp1
1175: SET tmp1.revenue_category = (SELECT evt.revenue_category_code
1176: FROM pa_event_types evt
1177: WHERE evt.event_type=tmp1.event_type)
1178: WHERE tmp1.revenue_category IS NULL
1179: AND tmp1.event_type IS NOT NULL;
1180: