APPS.PA_PROJECT_CORE2 dependencies on PA_JOB_BILL_TITLE_OVERRIDES

Line 990: INSERT INTO pa_job_bill_title_overrides (

986:
987: x_err_stage := 'copying task level job bill title overrides';
988: --Below condition added for selective copy project. Tracking Bug No. 3464332
989: IF 'Y' = l_fn_cb_overrides_flag THEN
990: INSERT INTO pa_job_bill_title_overrides (
991: JOB_ID
992: , LAST_UPDATE_DATE
993: , LAST_UPDATED_BY
994: , CREATION_DATE

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

1023: decode(new_tsk.start_date,
1024: null, o.end_date_active + x_delta,
1025: o.end_date_active +
1026: (new_tsk.start_date - old_tsk.start_date))))
1027: , pa_job_bill_title_overrides_s.NEXTVAL --Added the column for the bug 2581491
1028: FROM
1029: pa_job_bill_title_overrides o,
1030: pa_tasks old_tsk,
1031: pa_tasks new_tsk

Line 1029: pa_job_bill_title_overrides o,

1025: o.end_date_active +
1026: (new_tsk.start_date - old_tsk.start_date))))
1027: , pa_job_bill_title_overrides_s.NEXTVAL --Added the column for the bug 2581491
1028: FROM
1029: pa_job_bill_title_overrides o,
1030: pa_tasks old_tsk,
1031: pa_tasks new_tsk
1032: WHERE old_tsk.project_id = x_orig_project_id
1033: and o.task_id = old_tsk.task_id