APPS.PA_PROJECT_CORE2 dependencies on PA_JOB_BILL_RATE_OVERRIDES

Line 929: INSERT INTO pa_job_bill_rate_overrides (

925: FETCH cur_get_flag INTO l_fn_cb_overrides_flag;
926: CLOSE cur_get_flag;
927:
928: IF 'Y' = l_fn_cb_overrides_flag THEN
929: INSERT INTO pa_job_bill_rate_overrides (
930: JOB_ID
931: , START_DATE_ACTIVE
932: , LAST_UPDATE_DATE
933: , LAST_UPDATED_BY

Line 972: , pa_job_bill_rate_overrides_s.NEXTVAL -- added this column for bug 2476862

968: decode(new_tsk.start_date,
969: null, o.end_date_active + x_delta,
970: o.end_date_active +
971: (new_tsk.start_date - old_tsk.start_date))))
972: , pa_job_bill_rate_overrides_s.NEXTVAL -- added this column for bug 2476862
973: , o.RATE_CURRENCY_CODE -- added this column for bug 2581491
974: -- FP.K changes msundare
975: , o.DISCOUNT_PERCENTAGE
976: , o.RATE_DISC_REASON_CODE

Line 978: pa_job_bill_rate_overrides o,

974: -- FP.K changes msundare
975: , o.DISCOUNT_PERCENTAGE
976: , o.RATE_DISC_REASON_CODE
977: FROM
978: pa_job_bill_rate_overrides o,
979: pa_tasks old_tsk,
980: pa_tasks new_tsk
981: WHERE old_tsk.project_id = x_orig_project_id
982: and o.task_id = old_tsk.task_id