APPS.PA_PROJECT_CORE1 dependencies on PA_IND_RATE_SCH_REVISIONS

Line 4144: insert into pa_ind_rate_sch_revisions (

4140:
4141:
4142: x_err_stage := 'copying burden schedule revisions ';
4143:
4144: insert into pa_ind_rate_sch_revisions (
4145: IND_RATE_SCH_REVISION_ID,
4146: IND_RATE_SCH_ID,
4147: IND_RATE_SCH_REVISION,
4148: IND_RATE_SCH_REVISION_TYPE,

Line 4169: pa_ind_rate_sch_revisions_s.nextval,

4165: ORGANIZATION_STRUCTURE_ID,
4166: ORG_STRUCTURE_VERSION_ID,
4167: START_ORGANIZATION_ID) --Added these three columns for bug 2581491
4168: select
4169: pa_ind_rate_sch_revisions_s.nextval,
4170: new_sch.ind_rate_sch_id,
4171: rev.IND_RATE_SCH_REVISION,
4172: rev.IND_RATE_SCH_REVISION_TYPE,
4173: 'N',

Line 4194: from pa_ind_rate_sch_revisions rev,

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

Line 4236: pa_ind_rate_sch_revisions old_rev,

4232: FND_GLOBAL.USER_ID,
4233: sysdate,
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 =

Line 4237: pa_ind_rate_sch_revisions new_rev,

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