DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 924: INSERT INTO pa_project_asset_assignments (

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,
927: PROJECT_ID,
928: CREATION_DATE,

Line 942: from pa_project_asset_assignments assign,

938: FND_GLOBAL.USER_ID,
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

Line 967: from pa_project_asset_assignments assign,

963: FND_GLOBAL.USER_ID,
964: sysdate,
965: FND_GLOBAL.USER_ID,
966: FND_GLOBAL.LOGIN_ID
967: from pa_project_asset_assignments assign,
968: pa_tasks old_tsk,
969: pa_tasks new_tsk
970: where assign.project_id = x_orig_project_id
971: and assign.task_id = old_tsk.task_id