APPS.PA_PROJECT_CORE1 dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 4634: INSERT INTO pa_resource_list_assignments (

4630:
4631: -- end of copy project asset assignments
4632: x_err_stage := 'copying project resource list assignments';
4633:
4634: INSERT INTO pa_resource_list_assignments (
4635: RESOURCE_LIST_ASSIGNMENT_ID,
4636: RESOURCE_LIST_ID,
4637: PROJECT_ID,
4638: RESOURCE_LIST_CHANGED_FLAG,

Line 4645: pa_resource_list_assignments_s.nextval,

4641: CREATION_DATE,
4642: CREATED_BY,
4643: LAST_UPDATE_LOGIN )
4644: select
4645: pa_resource_list_assignments_s.nextval,
4646: RESOURCE_LIST_ID,
4647: x_new_project_id,
4648: 'N',
4649: FND_GLOBAL.USER_ID,

Line 4654: from pa_resource_list_assignments a,

4650: sysdate,
4651: sysdate,
4652: FND_GLOBAL.USER_ID,
4653: FND_GLOBAL.LOGIN_ID
4654: from pa_resource_list_assignments a,
4655: pa_resource_list_uses u
4656: where a.project_id = x_orig_project_id
4657: and a.resource_list_assignment_id =
4658: u.resource_list_assignment_id

Line 4683: pa_resource_list_assignments old_list,

4679: sysdate,
4680: FND_GLOBAL.USER_ID,
4681: FND_GLOBAL.LOGIN_ID
4682: from pa_resource_list_uses use,
4683: pa_resource_list_assignments old_list,
4684: pa_resource_list_assignments new_list
4685: where old_list.project_id = x_orig_project_id
4686: and old_list.RESOURCE_LIST_ASSIGNMENT_ID =
4687: use.RESOURCE_LIST_ASSIGNMENT_ID

Line 4684: pa_resource_list_assignments new_list

4680: FND_GLOBAL.USER_ID,
4681: FND_GLOBAL.LOGIN_ID
4682: from pa_resource_list_uses use,
4683: pa_resource_list_assignments old_list,
4684: pa_resource_list_assignments new_list
4685: where old_list.project_id = x_orig_project_id
4686: and old_list.RESOURCE_LIST_ASSIGNMENT_ID =
4687: use.RESOURCE_LIST_ASSIGNMENT_ID
4688: and use.use_code = 'ACTUALS_ACCUM'