APPS.PA_PROJECT_CORE1 dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 4586: INSERT INTO pa_resource_list_assignments (

4582:
4583: -- end of copy project asset assignments
4584: x_err_stage := 'copying project resource list assignments';
4585:
4586: INSERT INTO pa_resource_list_assignments (
4587: RESOURCE_LIST_ASSIGNMENT_ID,
4588: RESOURCE_LIST_ID,
4589: PROJECT_ID,
4590: RESOURCE_LIST_CHANGED_FLAG,

Line 4597: pa_resource_list_assignments_s.nextval,

4593: CREATION_DATE,
4594: CREATED_BY,
4595: LAST_UPDATE_LOGIN )
4596: select
4597: pa_resource_list_assignments_s.nextval,
4598: RESOURCE_LIST_ID,
4599: x_new_project_id,
4600: 'N',
4601: FND_GLOBAL.USER_ID,

Line 4606: from pa_resource_list_assignments a,

4602: sysdate,
4603: sysdate,
4604: FND_GLOBAL.USER_ID,
4605: FND_GLOBAL.LOGIN_ID
4606: from pa_resource_list_assignments a,
4607: pa_resource_list_uses u
4608: where a.project_id = x_orig_project_id
4609: and a.resource_list_assignment_id =
4610: u.resource_list_assignment_id

Line 4635: pa_resource_list_assignments old_list,

4631: sysdate,
4632: FND_GLOBAL.USER_ID,
4633: FND_GLOBAL.LOGIN_ID
4634: from pa_resource_list_uses use,
4635: pa_resource_list_assignments old_list,
4636: pa_resource_list_assignments new_list
4637: where old_list.project_id = x_orig_project_id
4638: and old_list.RESOURCE_LIST_ASSIGNMENT_ID =
4639: use.RESOURCE_LIST_ASSIGNMENT_ID

Line 4636: pa_resource_list_assignments new_list

4632: FND_GLOBAL.USER_ID,
4633: FND_GLOBAL.LOGIN_ID
4634: from pa_resource_list_uses use,
4635: pa_resource_list_assignments old_list,
4636: pa_resource_list_assignments new_list
4637: where old_list.project_id = x_orig_project_id
4638: and old_list.RESOURCE_LIST_ASSIGNMENT_ID =
4639: use.RESOURCE_LIST_ASSIGNMENT_ID
4640: and use.use_code = 'ACTUALS_ACCUM'