1214: END IF;
1215:
1216: x_err_stage := 'copying task level labor multipliers ';
1217:
1218: INSERT INTO pa_labor_multipliers (
1219: PROJECT_ID
1220: , TASK_ID
1221: , LABOR_MULTIPLIER
1222: , START_DATE_ACTIVE
1249: , FND_GLOBAL.USER_ID
1250: , sysdate
1251: , FND_GLOBAL.USER_ID
1252: , FND_GLOBAL.LOGIN_ID
1253: , pa_labor_multipliers_s.NEXTVAL --Added this column for the bug 2581491
1254: FROM pa_labor_multipliers m,
1255: pa_tasks old_tsk,
1256: pa_tasks new_tsk
1257: WHERE old_tsk.project_id = x_orig_project_id
1250: , sysdate
1251: , FND_GLOBAL.USER_ID
1252: , FND_GLOBAL.LOGIN_ID
1253: , pa_labor_multipliers_s.NEXTVAL --Added this column for the bug 2581491
1254: FROM pa_labor_multipliers m,
1255: pa_tasks old_tsk,
1256: pa_tasks new_tsk
1257: WHERE old_tsk.project_id = x_orig_project_id
1258: and m.task_id = old_tsk.task_id