APPS.PA_PROJECT_CORE2 dependencies on PA_JOB_ASSIGNMENT_OVERRIDES

Line 1098: INSERT INTO pa_job_assignment_overrides (

1094:
1095: x_err_stage := 'copying task level job assignment overrides';
1096: --Below condition added for selective copy project. Tracking Bug No. 3464332
1097: IF 'Y' = l_fn_cb_overrides_flag THEN
1098: INSERT INTO pa_job_assignment_overrides (
1099: PERSON_ID
1100: , LAST_UPDATE_DATE
1101: , LAST_UPDATED_BY
1102: , CREATION_DATE

Line 1137: , pa_job_assignment_overrides_s.NEXTVAL --Added the column for the bug 2581491

1133: decode(new_tsk.start_date,
1134: null, o.end_date_active + x_delta,
1135: o.end_date_active +
1136: (new_tsk.start_date - old_tsk.start_date))))
1137: , pa_job_assignment_overrides_s.NEXTVAL --Added the column for the bug 2581491
1138: FROM
1139: pa_job_assignment_overrides o,
1140: pa_tasks old_tsk,
1141: pa_tasks new_tsk

Line 1139: pa_job_assignment_overrides o,

1135: o.end_date_active +
1136: (new_tsk.start_date - old_tsk.start_date))))
1137: , pa_job_assignment_overrides_s.NEXTVAL --Added the column for the bug 2581491
1138: FROM
1139: pa_job_assignment_overrides o,
1140: pa_tasks old_tsk,
1141: pa_tasks new_tsk
1142: WHERE old_tsk.project_id = x_orig_project_id
1143: and o.task_id = old_tsk.task_id