APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_RESOURCE_ASSIGNMENTS_S

Line 4291: ,pa_resource_assignments_s.nextval

4287: -- cursor same_projects_cur is going to be used when the source and target projects are same
4288:
4289: CURSOR same_projects_cur IS
4290: SELECT resource_assignment_id
4291: ,pa_resource_assignments_s.nextval
4292: ,parent_assignment_id
4293: ,task_id
4294: ,task_id
4295: --Start of Changes for bug 3354518

Line 4321: ,pa_resource_assignments_s.NEXTVAL

4317: */
4318:
4319: CURSOR baseline_budgt_res_cur IS
4320: SELECT pra.resource_assignment_id
4321: ,pa_resource_assignments_s.NEXTVAL
4322: ,pra.parent_assignment_id
4323: ,pra.task_id
4324: ,pra.task_id
4325: --Start of Changes for bug 3354518

Line 4348: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID

4344: -- Reference to pa_tasks is changed to pa_struct_task_wbs_v (bug 3354518)
4345:
4346: CURSOR different_projects_task_cur IS
4347: SELECT pra.resource_assignment_id -- SOURCE_RES_ASSIGNMENT_ID
4348: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID
4349: ,pra.parent_assignment_id -- PARENT_ASSIGNMENT_ID
4350: ,pra.task_id -- SOURCE_TASK_ID
4351: ,target_tasks.task_id -- TARGET_TASK_ID
4352: ,NULL -- SOURCE ELEMENT_VERSION_ID

Line 4389: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID

4385: --is PROJECT and source and target project id is different.
4386:
4387: CURSOR proj_plan_lev_diff_proj_cur IS
4388: SELECT resource_assignment_id -- SOURCE_RES_ASSIGNMENT_ID
4389: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID
4390: ,NULL -- PARENT_ASSIGNMENT_ID
4391: ,0 -- SOURCE_TASK_ID
4392: ,0 -- TARGET_TASK_ID
4393: --Start of Changes for bug 3354518