APPS.PA_PROJECT_CORE1 dependencies on PA_IND_RATE_SCH_REVISIONS

Line 4192: insert into pa_ind_rate_sch_revisions (

4188:
4189:
4190: x_err_stage := 'copying burden schedule revisions ';
4191:
4192: insert into pa_ind_rate_sch_revisions (
4193: IND_RATE_SCH_REVISION_ID,
4194: IND_RATE_SCH_ID,
4195: IND_RATE_SCH_REVISION,
4196: IND_RATE_SCH_REVISION_TYPE,

Line 4217: pa_ind_rate_sch_revisions_s.nextval,

4213: ORGANIZATION_STRUCTURE_ID,
4214: ORG_STRUCTURE_VERSION_ID,
4215: START_ORGANIZATION_ID) --Added these three columns for bug 2581491
4216: select
4217: pa_ind_rate_sch_revisions_s.nextval,
4218: new_sch.ind_rate_sch_id,
4219: rev.IND_RATE_SCH_REVISION,
4220: rev.IND_RATE_SCH_REVISION_TYPE,
4221: 'N',

Line 4242: from pa_ind_rate_sch_revisions rev,

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

Line 4284: pa_ind_rate_sch_revisions old_rev,

4280: FND_GLOBAL.USER_ID,
4281: sysdate,
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 =

Line 4285: pa_ind_rate_sch_revisions new_rev,

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