APPS.IBE_INSTALLBASE_PVT dependencies on CSI_ITEM_INSTANCES

Line 26: FROM CSI_ITEM_INSTANCES INST

22: CURSOR c_connected_to_inst_id
23: (c_inst_hdr_id IN NUMBER, c_inst_rev_num IN NUMBER, c_inst_item_id IN NUMBER)
24: IS
25: SELECT INST.INSTANCE_ID
26: FROM CSI_ITEM_INSTANCES INST
27: WHERE INST.OWNER_PARTY_ID = p_owner_party_id
28: AND INST.OWNER_PARTY_ACCOUNT_ID = p_owner_party_account_id
29: AND INST.CONFIG_INST_HDR_ID = c_inst_hdr_id
30: AND INST.CONFIG_INST_REV_NUM = c_inst_rev_num

Line 43: FROM CSI_ITEM_INSTANCES CSII

39: -- Get the config inst header id and config inst revision number for
40: -- this instance id.
41: SELECT CSII.CONFIG_INST_HDR_ID, CSII.CONFIG_INST_REV_NUM
42: INTO l_config_inst_header_id, l_config_inst_revision_number
43: FROM CSI_ITEM_INSTANCES CSII
44: WHERE CSII.INSTANCE_ID = p_instance_id;
45:
46: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
47: IBE_Util.Debug('l_config_inst_header_id : '||l_config_inst_header_id);