DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_PROJECT_ASSETS

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

918: CLOSE cur_get_flag;
919:
920: -- added UNION to remove bug#604496 : ashia bagai 30-dec-97
921: -- Common Cost asset assignments would have an asset id = 0
922: -- and hence would not have a relevant record in pa_project_assets
923: IF 'Y' = l_fn_asset_assignments_flag AND 'Y' = l_fin_tasks_flag THEN
924: INSERT INTO pa_project_asset_assignments (
925: PROJECT_ASSET_ID,
926: TASK_ID,

Line 943: pa_project_assets old_asset,

939: sysdate,
940: FND_GLOBAL.USER_ID,
941: FND_GLOBAL.LOGIN_ID
942: from pa_project_asset_assignments assign,
943: pa_project_assets old_asset,
944: pa_project_assets new_asset,
945: pa_tasks old_tsk,
946: pa_tasks new_tsk
947: where old_asset.project_id = x_orig_project_id

Line 944: pa_project_assets new_asset,

940: FND_GLOBAL.USER_ID,
941: FND_GLOBAL.LOGIN_ID
942: from pa_project_asset_assignments assign,
943: pa_project_assets old_asset,
944: pa_project_assets new_asset,
945: pa_tasks old_tsk,
946: pa_tasks new_tsk
947: where old_asset.project_id = x_orig_project_id
948: and old_asset.project_asset_id = assign.project_asset_id