DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_PROJECT_ASSETS

Line 865: -- and hence would not have a relevant record in pa_project_assets

861: CLOSE cur_get_flag;
862:
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,

Line 886: pa_project_assets old_asset,

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
890: where old_asset.project_id = x_orig_project_id

Line 887: pa_project_assets new_asset,

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
890: where old_asset.project_id = x_orig_project_id
891: and old_asset.project_asset_id = assign.project_asset_id