DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_JOB_BILL_TITLE_OVERRIDES

Line 4750: INSERT INTO pa_job_bill_title_overrides (

4746: x_err_stage := 'copying project level job bill title overrides';
4747:
4748: --Below condition added for selective copy project. Tracking Bug No. 3464332
4749: IF 'Y' = l_fn_cb_overrides_flag THEN
4750: INSERT INTO pa_job_bill_title_overrides (
4751: JOB_ID
4752: , LAST_UPDATE_DATE
4753: , LAST_UPDATED_BY
4754: , CREATION_DATE

Line 4776: , pa_job_bill_title_overrides_s.NEXTVAL

4772: start_date_active + x_delta)
4773: , BILLING_TITLE
4774: , x_new_project_id
4775: , null
4776: , pa_job_bill_title_overrides_s.NEXTVAL
4777: , RECORD_VERSION_NUMBER
4778: , decode(x_delta, null, x_completion_date,
4779: end_date_active + x_delta)
4780: FROM

Line 4781: pa_job_bill_title_overrides

4777: , RECORD_VERSION_NUMBER
4778: , decode(x_delta, null, x_completion_date,
4779: end_date_active + x_delta)
4780: FROM
4781: pa_job_bill_title_overrides
4782: WHERE project_id = x_orig_project_id
4783: and task_id is null;
4784: END IF;
4785: