DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_EMP_BILL_RATE_OVERRIDES

Line 1094: INSERT into pa_emp_bill_rate_overrides (

1090:
1091: x_err_stage := 'copying task level emp bill rate overrides';
1092: --Below condition added for selective copy project. Tracking Bug No. 3464332
1093: IF 'Y' = l_fn_cb_overrides_flag THEN
1094: INSERT into pa_emp_bill_rate_overrides (
1095: PERSON_ID
1096: , LAST_UPDATE_DATE
1097: , LAST_UPDATED_BY
1098: , CREATION_DATE

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

1133: decode(new_tsk.start_date,
1134: null, o.end_date_active + x_delta,
1135: o.end_date_active +
1136: (new_tsk.start_date - old_tsk.start_date))))
1137: , pa_emp_bill_rate_overrides_s.NEXTVAL -- added this column for bug 2476862
1138: , o.RATE_CURRENCY_CODE -- added this column for bug 2581491
1139: -- Added for FP.K changes msundare
1140: , o.DISCOUNT_PERCENTAGE
1141: , o.RATE_DISC_REASON_CODE

Line 1143: pa_emp_bill_rate_overrides o,

1139: -- Added for FP.K changes msundare
1140: , o.DISCOUNT_PERCENTAGE
1141: , o.RATE_DISC_REASON_CODE
1142: FROM
1143: pa_emp_bill_rate_overrides o,
1144: pa_tasks old_tsk,
1145: pa_tasks new_tsk
1146: WHERE old_tsk.project_id = x_orig_project_id
1147: and o.task_id = old_tsk.task_id