DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_IND_RATE_SCH_REVISIONS

Line 556: insert into pa_ind_rate_sch_revisions (

552: AND new_tsk.task_number = old_tsk.task_number;
553:
554: x_err_stage := 'copying burden schedule revisions - task ';
555:
556: insert into pa_ind_rate_sch_revisions (
557: IND_RATE_SCH_REVISION_ID,
558: IND_RATE_SCH_ID,
559: IND_RATE_SCH_REVISION,
560: IND_RATE_SCH_REVISION_TYPE,

Line 581: pa_ind_rate_sch_revisions_s.nextval,

577: ORGANIZATION_STRUCTURE_ID, --Added these three columns for bug 2581491
578: ORG_STRUCTURE_VERSION_ID,
579: START_ORGANIZATION_ID)
580: select
581: pa_ind_rate_sch_revisions_s.nextval,
582: new_sch.ind_rate_sch_id,
583: rev.IND_RATE_SCH_REVISION,
584: rev.IND_RATE_SCH_REVISION_TYPE,
585: 'N',

Line 606: from pa_ind_rate_sch_revisions rev,

602: NULL,
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

Line 645: pa_ind_rate_sch_revisions old_rev,

641: FND_GLOBAL.USER_ID,
642: sysdate,
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,

Line 646: pa_ind_rate_sch_revisions new_rev,

642: sysdate,
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