APPS.CSI_MASS_EDIT_PUB dependencies on CSI_SYSTEMS_B

Line 2416: FROM CSI_SYSTEMS_B

2412: OBJECT_VERSION_NUMBER,
2413: OPERATING_UNIT_ID,
2414: PROGRAM_APPLICATION_ID,
2415: PROGRAM_ID
2416: FROM CSI_SYSTEMS_B
2417: WHERE SYSTEM_ID = p_system_id;
2418:
2419: CURSOR mu_system_tl_csr (p_system_id IN NUMBER) IS
2420: SELECT NAME,

Line 2776: CSI_SYSTEMS_B csb

2772: -- To get the count of active item instances in the system
2773: SELECT COUNT(1)
2774: INTO l_active_instance_count
2775: FROM csi_item_instances cisv,
2776: CSI_SYSTEMS_B csb
2777: WHERE cisv.SYSTEM_ID = l_mu_systems_csr.system_id
2778: AND cisv.system_id = csb.system_id
2779: AND NVL(cisv.ACTIVE_END_DATE,sysdate+1) > sysdate
2780: AND NVL(csb.END_DATE_ACTIVE,sysdate +1) > sysdate;