APPS.CSI_MASS_EDIT_PUB dependencies on CSI_SYSTEMS_B

Line 2301: FROM CSI_SYSTEMS_B

2297: OBJECT_VERSION_NUMBER,
2298: OPERATING_UNIT_ID,
2299: PROGRAM_APPLICATION_ID,
2300: PROGRAM_ID
2301: FROM CSI_SYSTEMS_B
2302: WHERE SYSTEM_ID = p_system_id;
2303:
2304: CURSOR mu_system_tl_csr (p_system_id IN NUMBER) IS
2305: SELECT NAME,

Line 2661: CSI_SYSTEMS_B csb

2657: -- To get the count of active item instances in the system
2658: SELECT COUNT(1)
2659: INTO l_active_instance_count
2660: FROM csi_item_instances cisv,
2661: CSI_SYSTEMS_B csb
2662: WHERE cisv.SYSTEM_ID = l_mu_systems_csr.system_id
2663: AND cisv.system_id = csb.system_id
2664: AND NVL(cisv.ACTIVE_END_DATE,sysdate+1) > sysdate
2665: AND NVL(csb.END_DATE_ACTIVE,sysdate +1) > sysdate;