APPS.CSI_ML_UTIL_PVT dependencies on PA_PROJECTS_ALL

Line 199: FROM pa_projects_all

195:
196: FORALL i9 in 1 .. inst_intf_id_upd.count
197: UPDATE csi_instance_interface a
198: SET a.project_id = (SELECT project_id
199: FROM pa_projects_all
200: WHERE segment1 = a.project_number)
201: WHERE inst_interface_id=inst_intf_id_upd(i9)
202: AND a.project_id IS NULL
203: AND a.project_number IS NOT NULL;

Line 209: pa_projects_all pp

205: FORALL i10 in 1 .. inst_intf_id_upd.count
206: UPDATE csi_instance_interface a
207: SET a.task_id = (SELECT task_id
208: FROM pa_tasks pt,
209: pa_projects_all pp
210: WHERE pt.task_number = a.task_number
211: AND pp.segment1 = a.project_number
212: AND pt.project_id = pp.project_id)
213: WHERE inst_interface_id=inst_intf_id_upd(i10)

Line 727: FROM pa_projects_all

723:
724: FORALL i9 in 1 .. inst_intf_id_upd.count
725: UPDATE csi_instance_interface a
726: SET a.project_id = (SELECT project_id
727: FROM pa_projects_all
728: WHERE segment1 = a.project_number)
729: WHERE inst_interface_id=inst_intf_id_upd(i9)
730: AND a.project_id IS NULL
731: AND a.project_number IS NOT NULL;

Line 737: pa_projects_all pp

733: FORALL i10 in 1 .. inst_intf_id_upd.count
734: UPDATE csi_instance_interface a
735: SET a.task_id = (SELECT task_id
736: FROM pa_tasks pt,
737: pa_projects_all pp
738: WHERE pt.task_number = a.task_number
739: AND pp.segment1 = a.project_number
740: AND pt.project_id = pp.project_id)
741: WHERE inst_interface_id=inst_intf_id_upd(i10)