DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 4564: INSERT INTO pa_project_asset_assignments (

4560: FETCH cur_get_flag INTO l_fn_asset_assignments_flag;
4561: CLOSE cur_get_flag;
4562:
4563: IF 'Y' = l_fn_asset_assignments_flag THEN
4564: INSERT INTO pa_project_asset_assignments (
4565: PROJECT_ASSET_ID,
4566: TASK_ID,
4567: PROJECT_ID,
4568: CREATION_DATE,

Line 4586: from pa_project_asset_assignments assign,

4582: FND_GLOBAL.USER_ID,
4583: sysdate,
4584: FND_GLOBAL.USER_ID,
4585: FND_GLOBAL.LOGIN_ID
4586: from pa_project_asset_assignments assign,
4587: pa_project_assets old_asset,
4588: pa_project_assets new_asset
4589: where old_asset.project_id = x_orig_project_id
4590: and old_asset.project_asset_id =

Line 4605: from pa_project_asset_assignments assign,

4601: FND_GLOBAL.USER_ID,
4602: sysdate,
4603: FND_GLOBAL.USER_ID,
4604: FND_GLOBAL.LOGIN_ID
4605: from pa_project_asset_assignments assign,
4606: pa_project_assets old_asset,
4607: pa_project_assets new_asset
4608: where old_asset.project_id = x_orig_project_id
4609: and old_asset.project_asset_id =

Line 4624: from pa_project_asset_assignments

4620: FND_GLOBAL.USER_ID,
4621: sysdate,
4622: FND_GLOBAL.USER_ID,
4623: FND_GLOBAL.LOGIN_ID
4624: from pa_project_asset_assignments
4625: where project_id = x_orig_project_id
4626: and task_id = 0
4627: and project_asset_id = 0;
4628: END IF;--IF 'Y' = l_fn_asset_assignments_flag THEN