631: instr(new_sch.ind_rate_sch_name, '-', -1))
632: = substr(old_sch.ind_rate_sch_name,
633: instr(old_sch.ind_rate_sch_name, '-', -1));
634:
635: insert into pa_ind_cost_multipliers (
636: IND_RATE_SCH_REVISION_ID,
637: ORGANIZATION_ID,
638: IND_COST_CODE,
639: MULTIPLIER,
651: FND_GLOBAL.USER_ID,
652: FND_GLOBAL.USER_ID,
653: sysdate,
654: FND_GLOBAL.LOGIN_ID
655: from pa_ind_cost_multipliers mult,
656: pa_ind_rate_sch_revisions old_rev,
657: pa_ind_rate_sch_revisions new_rev,
658: pa_ind_rate_schedules old_sch,
659: pa_ind_rate_schedules new_sch,