DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PVT dependencies on CSI_SYSTEMS_B

Line 2500: FROM CSI_SYSTEMS_B

2496: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl)
2497: IS
2498: CURSOR sys_active (p_system_id IN NUMBER) IS
2499: SELECT 1
2500: FROM CSI_SYSTEMS_B
2501: WHERE SYSTEM_ID = p_system_id
2502: AND (end_date_active is NULL OR
2503: nvl(end_date_active, sysdate+1) > sysdate);
2504:

Line 2548: FROM CSI_SYSTEMS_B

2544: p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl)
2545: IS
2546: CURSOR sys_customer_csr (p_system_id IN NUMBER) IS
2547: SELECT CUSTOMER_ID
2548: FROM CSI_SYSTEMS_B
2549: WHERE SYSTEM_ID = p_system_id;
2550:
2551: l_customer_id NUMBER := NULL;
2552: e_indx NUMBER := 0;