DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_JOB_ASSIGNMENT_OVERRIDES

Line 4742: INSERT INTO pa_job_assignment_overrides (

4738: x_err_stage := 'copying project level job assignment overrides';
4739:
4740: --Below condition added for selective copy project. Tracking Bug No. 3464332
4741: IF 'Y' = l_fn_cb_overrides_flag THEN
4742: INSERT INTO pa_job_assignment_overrides (
4743: PERSON_ID
4744: , LAST_UPDATE_DATE
4745: , LAST_UPDATED_BY
4746: , CREATION_DATE

Line 4770: , pa_job_assignment_overrides_s.NEXTVAL

4766: , x_new_project_id
4767: , null
4768: , JOB_ID
4769: , BILLING_TITLE
4770: , pa_job_assignment_overrides_s.NEXTVAL
4771: , RECORD_VERSION_NUMBER
4772: , decode(x_delta, null, x_completion_date,
4773: end_date_active + x_delta)
4774: FROM

Line 4775: pa_job_assignment_overrides

4771: , RECORD_VERSION_NUMBER
4772: , decode(x_delta, null, x_completion_date,
4773: end_date_active + x_delta)
4774: FROM
4775: pa_job_assignment_overrides
4776: WHERE project_id = x_orig_project_id
4777: and task_id is null;
4778: END IF;
4779: