DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_JOB_BILL_TITLE_OVERRIDES

Line 4702: INSERT INTO pa_job_bill_title_overrides (

4698: x_err_stage := 'copying project level job bill title overrides';
4699:
4700: --Below condition added for selective copy project. Tracking Bug No. 3464332
4701: IF 'Y' = l_fn_cb_overrides_flag THEN
4702: INSERT INTO pa_job_bill_title_overrides (
4703: JOB_ID
4704: , LAST_UPDATE_DATE
4705: , LAST_UPDATED_BY
4706: , CREATION_DATE

Line 4728: , pa_job_bill_title_overrides_s.NEXTVAL

4724: start_date_active + x_delta)
4725: , BILLING_TITLE
4726: , x_new_project_id
4727: , null
4728: , pa_job_bill_title_overrides_s.NEXTVAL
4729: , RECORD_VERSION_NUMBER
4730: , decode(x_delta, null, x_completion_date,
4731: end_date_active + x_delta)
4732: FROM

Line 4733: pa_job_bill_title_overrides

4729: , RECORD_VERSION_NUMBER
4730: , decode(x_delta, null, x_completion_date,
4731: end_date_active + x_delta)
4732: FROM
4733: pa_job_bill_title_overrides
4734: WHERE project_id = x_orig_project_id
4735: and task_id is null;
4736: END IF;
4737: