APPS.OKL_SPLIT_ASSET_PVT dependencies on CSI_INSTANCE_STATUSES

Line 4689: csi_instance_statuses csi_inst_sts,

4685: --Bug# 3569441
4686: csi.install_location_type_code, --hz_party_sites, hz_locations
4687: csi.instance_number
4688: FROM csi_item_instances csi,
4689: csi_instance_statuses csi_inst_sts,
4690: okc_k_items ib_cim,
4691: okc_k_lines_b ib_cle,
4692: okc_line_styles_b ib_lse,
4693: okc_k_lines_b inst_cle,

Line 13280: FROM CSI_INSTANCE_STATUSES

13276: --bug# 2648280
13277: --modified to get all the terminated statuses
13278: CURSOR inst_sts_csr(p_status_name IN VARCHAR2) IS
13279: SELECT instance_status_id
13280: FROM CSI_INSTANCE_STATUSES
13281: WHERE NVL(TERMINATED_FLAG,'N') = 'Y'
13282: AND name = p_status_name;
13283:
13284: l_expired_status_id csi_instance_statuses.instance_status_id%TYPE DEFAULT NULL;

Line 13284: l_expired_status_id csi_instance_statuses.instance_status_id%TYPE DEFAULT NULL;

13280: FROM CSI_INSTANCE_STATUSES
13281: WHERE NVL(TERMINATED_FLAG,'N') = 'Y'
13282: AND name = p_status_name;
13283:
13284: l_expired_status_id csi_instance_statuses.instance_status_id%TYPE DEFAULT NULL;
13285:
13286: l_active_instances_only VARCHAR2(1);
13287:
13288: --Bug # 2726870 11.5.9 enhancements - split asset into components