DBA Data[Home] [Help]

APPS.PA_MU_BATCHES_V_PKG dependencies on PA_PROJECTS_ALL

Line 600: FROM pa_projects_all p,

596: p.pm_project_reference,
597: decode(x_task_id,
598: NULL, NULL,
599: t.pm_task_reference) PM_TASK_REFERENCE
600: FROM pa_projects_all p,
601: pa_tasks t
602: WHERE p.project_id = x_project_id
603: AND t.project_id = p.project_id
604: AND ( x_task_id IS NULL

Line 810: UPDATE pa_projects_all

806:
807: IF (l_BatchLine_rec.task_id IS NULL) THEN
808: IF (X_Concurrent = 'Y') THEN
809:
810: UPDATE pa_projects_all
811: SET carrying_out_organization_id =
812: to_number(l_BatchLine_rec.new_attribute_value),
813: request_id = FND_GLOBAL.Conc_Request_ID,
814: program_application_id = FND_GLOBAL.Prog_Appl_ID,

Line 822: UPDATE pa_projects_all

818: WHERE project_id = l_BatchLine_rec.project_id;
819:
820: ELSE
821:
822: UPDATE pa_projects_all
823: SET carrying_out_organization_id =
824: to_number(l_BatchLine_rec.new_attribute_value),
825: last_updated_by = FND_GLOBAL.User_ID,
826: last_update_login = FND_GLOBAL.Login_ID,