APPS.IBE_INSTALLBASE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

    SELECT INST.INSTANCE_ID
    FROM CSI_ITEM_INSTANCES INST
    WHERE INST.OWNER_PARTY_ID = p_owner_party_id
    AND INST.OWNER_PARTY_ACCOUNT_ID = p_owner_party_account_id
    AND INST.CONFIG_INST_HDR_ID = c_inst_hdr_id
    AND INST.CONFIG_INST_REV_NUM = c_inst_rev_num
    AND INST.CONFIG_INST_ITEM_ID = c_inst_item_id ;

Line: 41

    SELECT CSII.CONFIG_INST_HDR_ID, CSII.CONFIG_INST_REV_NUM
    INTO l_config_inst_header_id, l_config_inst_revision_number
    FROM CSI_ITEM_INSTANCES CSII
    WHERE CSII.INSTANCE_ID = p_instance_id;

Line: 159

    SELECT 'Y' INTO l_return_value -- Set return val to Y if item exists in Msite
    FROM  DUAL
    WHERE EXISTS
    (
        SELECT si.inventory_item_id
        FROM ibe_dsp_msite_sct_items msi, ibe_dsp_section_items si
        WHERE  msi.section_item_id = si.section_item_id
        AND msi.mini_site_id = p_minisite_id
	AND si.inventory_item_id = p_inventory_item_id
    );