APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_RESOURCE_ASSIGNMENTS_S

Line 4290: ,pa_resource_assignments_s.nextval

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

Line 4320: ,pa_resource_assignments_s.NEXTVAL

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

Line 4347: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID

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

Line 4388: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID

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