489: -- copying burden schedule for Task:
490:
491: x_err_stage := 'copying task level burden schedules ';
492:
493: INSERT INTO pa_ind_rate_schedules (
494: IND_RATE_SCH_ID,
495: IND_RATE_SCH_NAME,
496: BUSINESS_GROUP_ID,
497: DESCRIPTION,
514: START_ORGANIZATION_ID,
515: IND_RATE_SCH_USAGE --bug 3053508
516: )
517: select
518: pa_ind_rate_schedules_s.nextval,
519: to_char(new_tsk.task_id) ||
520: substr(s.ind_rate_sch_name,
521: instr(s.ind_rate_sch_name, '-', -1)),
522: s.business_group_id,
540: s.ORGANIZATION_STRUCTURE_ID, --Added these 3 columns for the bug 2581491
541: s.ORG_STRUCTURE_VERSION_ID,
542: s.START_ORGANIZATION_ID,
543: s.IND_RATE_SCH_USAGE --bug 3053508
544: FROM pa_ind_rate_schedules s
545: , pa_tasks new_tsk
546: , pa_tasks old_tsk
547: WHERE
548: s.project_id = x_orig_project_id
603: rev.ORGANIZATION_STRUCTURE_ID, --Added these three columns for bug 2581491
604: rev.ORG_STRUCTURE_VERSION_ID,
605: rev.START_ORGANIZATION_ID
606: from pa_ind_rate_sch_revisions rev,
607: pa_ind_rate_schedules old_sch,
608: pa_ind_rate_schedules new_sch,
609: pa_tasks old_task,
610: pa_tasks new_task
611: where old_sch.project_id = x_orig_project_id
604: rev.ORG_STRUCTURE_VERSION_ID,
605: rev.START_ORGANIZATION_ID
606: from pa_ind_rate_sch_revisions rev,
607: pa_ind_rate_schedules old_sch,
608: pa_ind_rate_schedules new_sch,
609: pa_tasks old_task,
610: pa_tasks new_task
611: where old_sch.project_id = x_orig_project_id
612: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID
643: FND_GLOBAL.LOGIN_ID
644: from pa_ind_cost_multipliers mult,
645: pa_ind_rate_sch_revisions old_rev,
646: pa_ind_rate_sch_revisions new_rev,
647: pa_ind_rate_schedules old_sch,
648: pa_ind_rate_schedules new_sch,
649: pa_tasks old_task,
650: pa_tasks new_task
651: where old_rev.IND_RATE_SCH_REVISION_ID =
644: from pa_ind_cost_multipliers mult,
645: pa_ind_rate_sch_revisions old_rev,
646: pa_ind_rate_sch_revisions new_rev,
647: pa_ind_rate_schedules old_sch,
648: pa_ind_rate_schedules new_sch,
649: pa_tasks old_task,
650: pa_tasks new_task
651: where old_rev.IND_RATE_SCH_REVISION_ID =
652: mult.IND_RATE_SCH_REVISION_ID