APPS.PA_PROJECT_CORE1 dependencies on PA_JOB_ASSIGNMENT_OVERRIDES

Line 4790: INSERT INTO pa_job_assignment_overrides (

4786: x_err_stage := 'copying project level job assignment overrides';
4787:
4788: --Below condition added for selective copy project. Tracking Bug No. 3464332
4789: IF 'Y' = l_fn_cb_overrides_flag THEN
4790: INSERT INTO pa_job_assignment_overrides (
4791: PERSON_ID
4792: , LAST_UPDATE_DATE
4793: , LAST_UPDATED_BY
4794: , CREATION_DATE

Line 4818: , pa_job_assignment_overrides_s.NEXTVAL

4814: , x_new_project_id
4815: , null
4816: , JOB_ID
4817: , BILLING_TITLE
4818: , pa_job_assignment_overrides_s.NEXTVAL
4819: , RECORD_VERSION_NUMBER
4820: , decode(x_delta, null, x_completion_date,
4821: end_date_active + x_delta)
4822: FROM

Line 4823: pa_job_assignment_overrides

4819: , RECORD_VERSION_NUMBER
4820: , decode(x_delta, null, x_completion_date,
4821: end_date_active + x_delta)
4822: FROM
4823: pa_job_assignment_overrides
4824: WHERE project_id = x_orig_project_id
4825: and task_id is null;
4826: END IF;
4827: