APPS.PA_PROJECT_CORE2 dependencies on PA_JOB_BILL_TITLE_OVERRIDES

Line 1047: INSERT INTO pa_job_bill_title_overrides (

1043:
1044: x_err_stage := 'copying task level job bill title overrides';
1045: --Below condition added for selective copy project. Tracking Bug No. 3464332
1046: IF 'Y' = l_fn_cb_overrides_flag THEN
1047: INSERT INTO pa_job_bill_title_overrides (
1048: JOB_ID
1049: , LAST_UPDATE_DATE
1050: , LAST_UPDATED_BY
1051: , CREATION_DATE

Line 1084: , pa_job_bill_title_overrides_s.NEXTVAL --Added the column for the bug 2581491

1080: decode(new_tsk.start_date,
1081: null, o.end_date_active + x_delta,
1082: o.end_date_active +
1083: (new_tsk.start_date - old_tsk.start_date))))
1084: , pa_job_bill_title_overrides_s.NEXTVAL --Added the column for the bug 2581491
1085: FROM
1086: pa_job_bill_title_overrides o,
1087: pa_tasks old_tsk,
1088: pa_tasks new_tsk

Line 1086: pa_job_bill_title_overrides o,

1082: o.end_date_active +
1083: (new_tsk.start_date - old_tsk.start_date))))
1084: , pa_job_bill_title_overrides_s.NEXTVAL --Added the column for the bug 2581491
1085: FROM
1086: pa_job_bill_title_overrides o,
1087: pa_tasks old_tsk,
1088: pa_tasks new_tsk
1089: WHERE old_tsk.project_id = x_orig_project_id
1090: and o.task_id = old_tsk.task_id