DBA Data[Home] [Help]

APPS.PA_RP_UTIL dependencies on PA_RP_JOB_ASSIGNMENTS_HISTORY

Line 338: INSERT INTO pa_rp_job_assignments_history

334: END IF;
335: END LOOP;
336:
337: /* Move the job assignment record into history table */
338: INSERT INTO pa_rp_job_assignments_history
339: (ASSIGNMENT_ID, MAIN_REQUEST_ID, WORKER_REQUEST_ID, STATUS_FLAG, RP_ID, BURSTING_VALUE_1, BURSTING_VALUE_2, BURSTING_VALUE_3, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN)
340: SELECT ASSIGNMENT_ID, MAIN_REQUEST_ID, WORKER_REQUEST_ID, STATUS_FLAG, RP_ID, BURSTING_VALUE_1, BURSTING_VALUE_2, BURSTING_VALUE_3, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN FROM pa_rp_job_assignments
341: WHERE main_request_id = p_main_request_id;
342: