APPS.PA_PROJECT_CORE1 dependencies on PA_IND_RATE_SCHEDULES

Line 4129: INSERT INTO pa_ind_rate_schedules (

4125: -- copying burden schedule for project:
4126:
4127: x_err_stage := 'copying project level burden schedules ';
4128:
4129: INSERT INTO pa_ind_rate_schedules (
4130: IND_RATE_SCH_ID,
4131: IND_RATE_SCH_NAME,
4132: BUSINESS_GROUP_ID,
4133: DESCRIPTION,

Line 4154: pa_ind_rate_schedules_s.nextval,

4150: START_ORGANIZATION_ID, --Added these three columns for bug 2581491
4151: IND_RATE_SCH_USAGE --bug 3053508
4152: )
4153: select
4154: pa_ind_rate_schedules_s.nextval,
4155: -- to_char(x_new_project_id) ||
4156: -- substr(s.ind_rate_sch_name,
4157: -- instr(s.ind_rate_sch_name, '-', -1)),
4158: SUBSTR((TO_CHAR(x_new_project_id) ||

Line 4185: pa_ind_rate_schedules s

4181: s.ORG_STRUCTURE_VERSION_ID,
4182: s.START_ORGANIZATION_ID , --Added these three columns for bug 2581491
4183: s.IND_RATE_SCH_USAGE --bug 3053508
4184: FROM
4185: pa_ind_rate_schedules s
4186: WHERE s.project_id = x_orig_project_id
4187: and s.task_id is null;
4188:
4189:

Line 4243: pa_ind_rate_schedules old_sch,

4239: rev.ORGANIZATION_STRUCTURE_ID,
4240: rev.ORG_STRUCTURE_VERSION_ID,
4241: rev.START_ORGANIZATION_ID --Added these three columns for bug 2581491
4242: from pa_ind_rate_sch_revisions rev,
4243: pa_ind_rate_schedules old_sch,
4244: pa_ind_rate_schedules new_sch
4245: where old_sch.project_id = x_orig_project_id
4246: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID
4247: and old_sch.task_id is null

Line 4244: pa_ind_rate_schedules new_sch

4240: rev.ORG_STRUCTURE_VERSION_ID,
4241: rev.START_ORGANIZATION_ID --Added these three columns for bug 2581491
4242: from pa_ind_rate_sch_revisions rev,
4243: pa_ind_rate_schedules old_sch,
4244: pa_ind_rate_schedules new_sch
4245: where old_sch.project_id = x_orig_project_id
4246: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID
4247: and old_sch.task_id is null
4248: and new_sch.project_id = x_new_project_id

Line 4286: pa_ind_rate_schedules old_sch,

4282: FND_GLOBAL.LOGIN_ID
4283: from pa_ind_cost_multipliers mult,
4284: pa_ind_rate_sch_revisions old_rev,
4285: pa_ind_rate_sch_revisions new_rev,
4286: pa_ind_rate_schedules old_sch,
4287: pa_ind_rate_schedules new_sch
4288: where old_rev.IND_RATE_SCH_REVISION_ID =
4289: mult.IND_RATE_SCH_REVISION_ID
4290: and old_rev.IND_RATE_SCH_REVISION =

Line 4287: pa_ind_rate_schedules new_sch

4283: from pa_ind_cost_multipliers mult,
4284: pa_ind_rate_sch_revisions old_rev,
4285: pa_ind_rate_sch_revisions new_rev,
4286: pa_ind_rate_schedules old_sch,
4287: pa_ind_rate_schedules new_sch
4288: where old_rev.IND_RATE_SCH_REVISION_ID =
4289: mult.IND_RATE_SCH_REVISION_ID
4290: and old_rev.IND_RATE_SCH_REVISION =
4291: new_rev.IND_RATE_SCH_REVISION