APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 4516: INSERT INTO pa_project_asset_assignments (

4512: FETCH cur_get_flag INTO l_fn_asset_assignments_flag;
4513: CLOSE cur_get_flag;
4514:
4515: IF 'Y' = l_fn_asset_assignments_flag THEN
4516: INSERT INTO pa_project_asset_assignments (
4517: PROJECT_ASSET_ID,
4518: TASK_ID,
4519: PROJECT_ID,
4520: CREATION_DATE,

Line 4538: from pa_project_asset_assignments assign,

4534: FND_GLOBAL.USER_ID,
4535: sysdate,
4536: FND_GLOBAL.USER_ID,
4537: FND_GLOBAL.LOGIN_ID
4538: from pa_project_asset_assignments assign,
4539: pa_project_assets old_asset,
4540: pa_project_assets new_asset
4541: where old_asset.project_id = x_orig_project_id
4542: and old_asset.project_asset_id =

Line 4557: from pa_project_asset_assignments assign,

4553: FND_GLOBAL.USER_ID,
4554: sysdate,
4555: FND_GLOBAL.USER_ID,
4556: FND_GLOBAL.LOGIN_ID
4557: from pa_project_asset_assignments assign,
4558: pa_project_assets old_asset,
4559: pa_project_assets new_asset
4560: where old_asset.project_id = x_orig_project_id
4561: and old_asset.project_asset_id =

Line 4576: from pa_project_asset_assignments

4572: FND_GLOBAL.USER_ID,
4573: sysdate,
4574: FND_GLOBAL.USER_ID,
4575: FND_GLOBAL.LOGIN_ID
4576: from pa_project_asset_assignments
4577: where project_id = x_orig_project_id
4578: and task_id = 0
4579: and project_asset_id = 0;
4580: END IF;--IF 'Y' = l_fn_asset_assignments_flag THEN