DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_JOB_BILL_RATE_OVERRIDES

Line 986: INSERT INTO pa_job_bill_rate_overrides (

982: FETCH cur_get_flag INTO l_fn_cb_overrides_flag;
983: CLOSE cur_get_flag;
984:
985: IF 'Y' = l_fn_cb_overrides_flag THEN
986: INSERT INTO pa_job_bill_rate_overrides (
987: JOB_ID
988: , START_DATE_ACTIVE
989: , LAST_UPDATE_DATE
990: , LAST_UPDATED_BY

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

1025: decode(new_tsk.start_date,
1026: null, o.end_date_active + x_delta,
1027: o.end_date_active +
1028: (new_tsk.start_date - old_tsk.start_date))))
1029: , pa_job_bill_rate_overrides_s.NEXTVAL -- added this column for bug 2476862
1030: , o.RATE_CURRENCY_CODE -- added this column for bug 2581491
1031: -- FP.K changes msundare
1032: , o.DISCOUNT_PERCENTAGE
1033: , o.RATE_DISC_REASON_CODE

Line 1035: pa_job_bill_rate_overrides o,

1031: -- FP.K changes msundare
1032: , o.DISCOUNT_PERCENTAGE
1033: , o.RATE_DISC_REASON_CODE
1034: FROM
1035: pa_job_bill_rate_overrides o,
1036: pa_tasks old_tsk,
1037: pa_tasks new_tsk
1038: WHERE old_tsk.project_id = x_orig_project_id
1039: and o.task_id = old_tsk.task_id