APPS.CSI_SYSTEMS_PVT dependencies on CSI_SYSTEMS_VL

Line 1135: FROM csi_systems_vl

1131: x_msg_count OUT NOCOPY NUMBER ,
1132: x_msg_data OUT NOCOPY VARCHAR2) IS
1133: CURSOR dup_cur IS
1134: SELECT 'x'
1135: FROM csi_systems_vl
1136: WHERE name = p_Name
1137: AND customer_id = p_Customer_ID
1138: --AND system_number = nvl(p_System_number,system_number)
1139: AND (system_number IS NULL OR

Line 5812: FROM CSI_SYSTEMS_VL

5808: SELECT name
5809: ,description
5810: INTO p_system_header_tbl(sys_row).name
5811: ,p_system_header_tbl(sys_row).description
5812: FROM CSI_SYSTEMS_VL
5813: WHERE system_id = p_system_header_tbl(sys_row).system_id;
5814: EXCEPTION
5815: WHEN OTHERS THEN
5816: NULL;

Line 6066: FROM CSI_SYSTEMS_VL

6062: SELECT name
6063: ,description
6064: INTO p_system_header_tbl(sys_row).parent_name
6065: ,p_system_header_tbl(sys_row).parent_description
6066: FROM CSI_SYSTEMS_VL
6067: WHERE system_id = p_system_header_tbl(sys_row).parent_system_id;
6068: EXCEPTION
6069: WHEN OTHERS THEN
6070: NULL;