DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_IND_RATE_SCHEDULES

Line 501: INSERT INTO pa_ind_rate_schedules (

497: -- copying burden schedule for Task:
498:
499: x_err_stage := 'copying task level burden schedules ';
500:
501: INSERT INTO pa_ind_rate_schedules (
502: IND_RATE_SCH_ID,
503: IND_RATE_SCH_NAME,
504: BUSINESS_GROUP_ID,
505: DESCRIPTION,

Line 526: pa_ind_rate_schedules_s.nextval,

522: START_ORGANIZATION_ID,
523: IND_RATE_SCH_USAGE --bug 3053508
524: )
525: select
526: pa_ind_rate_schedules_s.nextval,
527: /*to_char(new_tsk.task_id) ||
528: substr(s.ind_rate_sch_name,
529: instr(s.ind_rate_sch_name, '-', -1)),*/
530: SUBSTRB((TO_CHAR(new_tsk.task_id) || DECODE(INSTRB(s.ind_rate_sch_name, '-',

Line 555: FROM pa_ind_rate_schedules s

551: s.ORGANIZATION_STRUCTURE_ID, --Added these 3 columns for the bug 2581491
552: s.ORG_STRUCTURE_VERSION_ID,
553: s.START_ORGANIZATION_ID,
554: s.IND_RATE_SCH_USAGE --bug 3053508
555: FROM pa_ind_rate_schedules s
556: , pa_tasks new_tsk
557: , pa_tasks old_tsk
558: WHERE
559: s.project_id = x_orig_project_id

Line 618: pa_ind_rate_schedules old_sch,

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
622: where old_sch.project_id = x_orig_project_id

Line 619: pa_ind_rate_schedules new_sch,

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
622: where old_sch.project_id = x_orig_project_id
623: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID

Line 658: pa_ind_rate_schedules old_sch,

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
662: where old_rev.IND_RATE_SCH_REVISION_ID =

Line 659: pa_ind_rate_schedules new_sch,

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
662: where old_rev.IND_RATE_SCH_REVISION_ID =
663: mult.IND_RATE_SCH_REVISION_ID