DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_IND_RATE_SCH_REVISIONS

Line 567: insert into pa_ind_rate_sch_revisions (

563: AND new_tsk.task_number = old_tsk.task_number;
564:
565: x_err_stage := 'copying burden schedule revisions - task ';
566:
567: insert into pa_ind_rate_sch_revisions (
568: IND_RATE_SCH_REVISION_ID,
569: IND_RATE_SCH_ID,
570: IND_RATE_SCH_REVISION,
571: IND_RATE_SCH_REVISION_TYPE,

Line 592: pa_ind_rate_sch_revisions_s.nextval,

588: ORGANIZATION_STRUCTURE_ID, --Added these three columns for bug 2581491
589: ORG_STRUCTURE_VERSION_ID,
590: START_ORGANIZATION_ID)
591: select
592: pa_ind_rate_sch_revisions_s.nextval,
593: new_sch.ind_rate_sch_id,
594: rev.IND_RATE_SCH_REVISION,
595: rev.IND_RATE_SCH_REVISION_TYPE,
596: 'N',

Line 617: from pa_ind_rate_sch_revisions rev,

613: NULL,
614: rev.ORGANIZATION_STRUCTURE_ID, --Added these three columns for bug 2581491
615: rev.ORG_STRUCTURE_VERSION_ID,
616: rev.START_ORGANIZATION_ID
617: from pa_ind_rate_sch_revisions rev,
618: pa_ind_rate_schedules old_sch,
619: pa_ind_rate_schedules new_sch,
620: pa_tasks old_task,
621: pa_tasks new_task

Line 656: pa_ind_rate_sch_revisions old_rev,

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,
660: pa_tasks old_task,

Line 657: pa_ind_rate_sch_revisions new_rev,

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,
660: pa_tasks old_task,
661: pa_tasks new_task