[Home] [Help]
863: -- added UNION to remove bug#604496 : ashia bagai 30-dec-97
864: -- Common Cost asset assignments would have an asset id = 0
865: -- and hence would not have a relevant record in pa_project_assets
866: IF 'Y' = l_fn_asset_assignments_flag AND 'Y' = l_fin_tasks_flag THEN
867: INSERT INTO pa_project_asset_assignments (
868: PROJECT_ASSET_ID,
869: TASK_ID,
870: PROJECT_ID,
871: CREATION_DATE,
881: FND_GLOBAL.USER_ID,
882: sysdate,
883: FND_GLOBAL.USER_ID,
884: FND_GLOBAL.LOGIN_ID
885: from pa_project_asset_assignments assign,
886: pa_project_assets old_asset,
887: pa_project_assets new_asset,
888: pa_tasks old_tsk,
889: pa_tasks new_tsk
906: FND_GLOBAL.USER_ID,
907: sysdate,
908: FND_GLOBAL.USER_ID,
909: FND_GLOBAL.LOGIN_ID
910: from pa_project_asset_assignments assign,
911: pa_tasks old_tsk,
912: pa_tasks new_tsk
913: where assign.project_id = x_orig_project_id
914: and assign.task_id = old_tsk.task_id