APPS.PA_PROJECT_CORE2 dependencies on PA_NL_BILL_RATE_OVERRIDES

Line 1155: INSERT INTO pa_nl_bill_rate_overrides (

1151:
1152: x_err_stage := 'copying task level nl bill rate overrides';
1153: --Below condition added for selective copy project. Tracking Bug No. 3464332
1154: IF 'Y' = l_fn_cb_overrides_flag THEN
1155: INSERT INTO pa_nl_bill_rate_overrides (
1156: EXPENDITURE_TYPE
1157: , LAST_UPDATE_DATE
1158: , LAST_UPDATED_BY
1159: , CREATION_DATE

Line 1201: , pa_nl_bill_rate_overrides_s.NEXTVAL -- added this column for bug 2476862

1197: decode(new_tsk.start_date,
1198: null, o.end_date_active + x_delta,
1199: o.end_date_active +
1200: (new_tsk.start_date - old_tsk.start_date))))
1201: , pa_nl_bill_rate_overrides_s.NEXTVAL -- added this column for bug 2476862
1202: , o.RATE_CURRENCY_CODE -- added this column for bug 2581491
1203: -- FP.K changes msundare
1204: , o.DISCOUNT_PERCENTAGE
1205: , o.RATE_DISC_REASON_CODE

Line 1207: pa_nl_bill_rate_overrides o,

1203: -- FP.K changes msundare
1204: , o.DISCOUNT_PERCENTAGE
1205: , o.RATE_DISC_REASON_CODE
1206: FROM
1207: pa_nl_bill_rate_overrides o,
1208: pa_tasks old_tsk,
1209: pa_tasks new_tsk
1210: WHERE old_tsk.project_id = x_orig_project_id
1211: and o.task_id = old_tsk.task_id