APPS.PA_PROJECT_CORE1 dependencies on PA_IND_RATE_SCHEDULES

Line 4081: INSERT INTO pa_ind_rate_schedules (

4077: -- copying burden schedule for project:
4078:
4079: x_err_stage := 'copying project level burden schedules ';
4080:
4081: INSERT INTO pa_ind_rate_schedules (
4082: IND_RATE_SCH_ID,
4083: IND_RATE_SCH_NAME,
4084: BUSINESS_GROUP_ID,
4085: DESCRIPTION,

Line 4106: pa_ind_rate_schedules_s.nextval,

4102: START_ORGANIZATION_ID, --Added these three columns for bug 2581491
4103: IND_RATE_SCH_USAGE --bug 3053508
4104: )
4105: select
4106: pa_ind_rate_schedules_s.nextval,
4107: -- to_char(x_new_project_id) ||
4108: -- substr(s.ind_rate_sch_name,
4109: -- instr(s.ind_rate_sch_name, '-', -1)),
4110: SUBSTR((TO_CHAR(x_new_project_id) ||

Line 4137: pa_ind_rate_schedules s

4133: s.ORG_STRUCTURE_VERSION_ID,
4134: s.START_ORGANIZATION_ID , --Added these three columns for bug 2581491
4135: s.IND_RATE_SCH_USAGE --bug 3053508
4136: FROM
4137: pa_ind_rate_schedules s
4138: WHERE s.project_id = x_orig_project_id
4139: and s.task_id is null;
4140:
4141:

Line 4195: pa_ind_rate_schedules old_sch,

4191: rev.ORGANIZATION_STRUCTURE_ID,
4192: rev.ORG_STRUCTURE_VERSION_ID,
4193: rev.START_ORGANIZATION_ID --Added these three columns for bug 2581491
4194: from pa_ind_rate_sch_revisions rev,
4195: pa_ind_rate_schedules old_sch,
4196: pa_ind_rate_schedules new_sch
4197: where old_sch.project_id = x_orig_project_id
4198: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID
4199: and old_sch.task_id is null

Line 4196: pa_ind_rate_schedules new_sch

4192: rev.ORG_STRUCTURE_VERSION_ID,
4193: rev.START_ORGANIZATION_ID --Added these three columns for bug 2581491
4194: from pa_ind_rate_sch_revisions rev,
4195: pa_ind_rate_schedules old_sch,
4196: pa_ind_rate_schedules new_sch
4197: where old_sch.project_id = x_orig_project_id
4198: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID
4199: and old_sch.task_id is null
4200: and new_sch.project_id = x_new_project_id

Line 4238: pa_ind_rate_schedules old_sch,

4234: FND_GLOBAL.LOGIN_ID
4235: from pa_ind_cost_multipliers mult,
4236: pa_ind_rate_sch_revisions old_rev,
4237: pa_ind_rate_sch_revisions new_rev,
4238: pa_ind_rate_schedules old_sch,
4239: pa_ind_rate_schedules new_sch
4240: where old_rev.IND_RATE_SCH_REVISION_ID =
4241: mult.IND_RATE_SCH_REVISION_ID
4242: and old_rev.IND_RATE_SCH_REVISION =

Line 4239: pa_ind_rate_schedules new_sch

4235: from pa_ind_cost_multipliers mult,
4236: pa_ind_rate_sch_revisions old_rev,
4237: pa_ind_rate_sch_revisions new_rev,
4238: pa_ind_rate_schedules old_sch,
4239: pa_ind_rate_schedules new_sch
4240: where old_rev.IND_RATE_SCH_REVISION_ID =
4241: mult.IND_RATE_SCH_REVISION_ID
4242: and old_rev.IND_RATE_SCH_REVISION =
4243: new_rev.IND_RATE_SCH_REVISION