DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_EMP_BILL_RATE_OVERRIDES

Line 1151: INSERT into pa_emp_bill_rate_overrides (

1147:
1148: x_err_stage := 'copying task level emp bill rate overrides';
1149: --Below condition added for selective copy project. Tracking Bug No. 3464332
1150: IF 'Y' = l_fn_cb_overrides_flag THEN
1151: INSERT into pa_emp_bill_rate_overrides (
1152: PERSON_ID
1153: , LAST_UPDATE_DATE
1154: , LAST_UPDATED_BY
1155: , CREATION_DATE

Line 1194: , pa_emp_bill_rate_overrides_s.NEXTVAL -- added this column for bug 2476862

1190: decode(new_tsk.start_date,
1191: null, o.end_date_active + x_delta,
1192: o.end_date_active +
1193: (new_tsk.start_date - old_tsk.start_date))))
1194: , pa_emp_bill_rate_overrides_s.NEXTVAL -- added this column for bug 2476862
1195: , o.RATE_CURRENCY_CODE -- added this column for bug 2581491
1196: -- Added for FP.K changes msundare
1197: , o.DISCOUNT_PERCENTAGE
1198: , o.RATE_DISC_REASON_CODE

Line 1200: pa_emp_bill_rate_overrides o,

1196: -- Added for FP.K changes msundare
1197: , o.DISCOUNT_PERCENTAGE
1198: , o.RATE_DISC_REASON_CODE
1199: FROM
1200: pa_emp_bill_rate_overrides o,
1201: pa_tasks old_tsk,
1202: pa_tasks new_tsk
1203: WHERE old_tsk.project_id = x_orig_project_id
1204: and o.task_id = old_tsk.task_id