APPS.PA_PROJECT_CORE2 dependencies on PA_NL_BILL_RATE_OVERRIDES

Line 1212: INSERT INTO pa_nl_bill_rate_overrides (

1208:
1209: x_err_stage := 'copying task level nl bill rate overrides';
1210: --Below condition added for selective copy project. Tracking Bug No. 3464332
1211: IF 'Y' = l_fn_cb_overrides_flag THEN
1212: INSERT INTO pa_nl_bill_rate_overrides (
1213: EXPENDITURE_TYPE
1214: , LAST_UPDATE_DATE
1215: , LAST_UPDATED_BY
1216: , CREATION_DATE

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

1254: decode(new_tsk.start_date,
1255: null, o.end_date_active + x_delta,
1256: o.end_date_active +
1257: (new_tsk.start_date - old_tsk.start_date))))
1258: , pa_nl_bill_rate_overrides_s.NEXTVAL -- added this column for bug 2476862
1259: , o.RATE_CURRENCY_CODE -- added this column for bug 2581491
1260: -- FP.K changes msundare
1261: , o.DISCOUNT_PERCENTAGE
1262: , o.RATE_DISC_REASON_CODE

Line 1264: pa_nl_bill_rate_overrides o,

1260: -- FP.K changes msundare
1261: , o.DISCOUNT_PERCENTAGE
1262: , o.RATE_DISC_REASON_CODE
1263: FROM
1264: pa_nl_bill_rate_overrides o,
1265: pa_tasks old_tsk,
1266: pa_tasks new_tsk
1267: WHERE old_tsk.project_id = x_orig_project_id
1268: and o.task_id = old_tsk.task_id