APPS.OKL_SPLIT_ASSET_PVT dependencies on CSI_INSTANCE_STATUSES

Line 4717: csi_instance_statuses csi_inst_sts,

4713: --Bug# 3569441
4714: csi.install_location_type_code, --hz_party_sites, hz_locations
4715: csi.instance_number
4716: FROM csi_item_instances csi,
4717: csi_instance_statuses csi_inst_sts,
4718: okc_k_items ib_cim,
4719: okc_k_lines_b ib_cle,
4720: okc_line_styles_b ib_lse,
4721: okc_k_lines_b inst_cle,

Line 13333: FROM CSI_INSTANCE_STATUSES

13329: --bug# 2648280
13330: --modified to get all the terminated statuses
13331: CURSOR inst_sts_csr(p_status_name IN VARCHAR2) IS
13332: SELECT instance_status_id
13333: FROM CSI_INSTANCE_STATUSES
13334: WHERE NVL(TERMINATED_FLAG,'N') = 'Y'
13335: AND name = p_status_name;
13336:
13337: l_expired_status_id csi_instance_statuses.instance_status_id%TYPE DEFAULT NULL;

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

13333: FROM CSI_INSTANCE_STATUSES
13334: WHERE NVL(TERMINATED_FLAG,'N') = 'Y'
13335: AND name = p_status_name;
13336:
13337: l_expired_status_id csi_instance_statuses.instance_status_id%TYPE DEFAULT NULL;
13338:
13339: l_active_instances_only VARCHAR2(1);
13340:
13341: --Bug # 2726870 11.5.9 enhancements - split asset into components