[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ID,
FLEX_TITLE,
PRICING_CONTEXT,
PRICING_ATTRIBUTE1,
CHR_ID,
PRICING_ATTRIBUTE2,
CLE_ID,
PRICING_ATTRIBUTE3,
PRICING_ATTRIBUTE4,
PRICING_ATTRIBUTE5,
PRICING_ATTRIBUTE6,
PRICING_ATTRIBUTE7,
PRICING_ATTRIBUTE8,
PRICING_ATTRIBUTE9,
PRICING_ATTRIBUTE10,
PRICING_ATTRIBUTE11,
PRICING_ATTRIBUTE12,
PRICING_ATTRIBUTE13,
PRICING_ATTRIBUTE14,
PRICING_ATTRIBUTE15,
PRICING_ATTRIBUTE16,
PRICING_ATTRIBUTE17,
PRICING_ATTRIBUTE18,
PRICING_ATTRIBUTE19,
PRICING_ATTRIBUTE20,
PRICING_ATTRIBUTE21,
PRICING_ATTRIBUTE22,
PRICING_ATTRIBUTE23,
PRICING_ATTRIBUTE24,
PRICING_ATTRIBUTE25,
PRICING_ATTRIBUTE26,
PRICING_ATTRIBUTE27,
PRICING_ATTRIBUTE28,
PRICING_ATTRIBUTE29,
PRICING_ATTRIBUTE30,
PRICING_ATTRIBUTE31,
PRICING_ATTRIBUTE32,
PRICING_ATTRIBUTE33,
PRICING_ATTRIBUTE34,
PRICING_ATTRIBUTE35,
PRICING_ATTRIBUTE36,
PRICING_ATTRIBUTE37,
PRICING_ATTRIBUTE38,
PRICING_ATTRIBUTE39,
PRICING_ATTRIBUTE40,
PRICING_ATTRIBUTE41,
PRICING_ATTRIBUTE42,
PRICING_ATTRIBUTE43,
PRICING_ATTRIBUTE44,
PRICING_ATTRIBUTE45,
PRICING_ATTRIBUTE46,
PRICING_ATTRIBUTE47,
PRICING_ATTRIBUTE48,
PRICING_ATTRIBUTE49,
PRICING_ATTRIBUTE50,
PRICING_ATTRIBUTE51,
PRICING_ATTRIBUTE52,
PRICING_ATTRIBUTE53,
PRICING_ATTRIBUTE54,
PRICING_ATTRIBUTE55,
PRICING_ATTRIBUTE56,
PRICING_ATTRIBUTE57,
PRICING_ATTRIBUTE58,
PRICING_ATTRIBUTE59,
PRICING_ATTRIBUTE60,
PRICING_ATTRIBUTE61,
PRICING_ATTRIBUTE62,
PRICING_ATTRIBUTE63,
PRICING_ATTRIBUTE64,
PRICING_ATTRIBUTE65,
PRICING_ATTRIBUTE66,
PRICING_ATTRIBUTE67,
PRICING_ATTRIBUTE68,
PRICING_ATTRIBUTE69,
PRICING_ATTRIBUTE70,
PRICING_ATTRIBUTE71,
PRICING_ATTRIBUTE72,
PRICING_ATTRIBUTE73,
PRICING_ATTRIBUTE74,
PRICING_ATTRIBUTE75,
PRICING_ATTRIBUTE76,
PRICING_ATTRIBUTE77,
PRICING_ATTRIBUTE78,
PRICING_ATTRIBUTE79,
PRICING_ATTRIBUTE80,
PRICING_ATTRIBUTE81,
PRICING_ATTRIBUTE82,
PRICING_ATTRIBUTE83,
PRICING_ATTRIBUTE84,
PRICING_ATTRIBUTE85,
PRICING_ATTRIBUTE86,
PRICING_ATTRIBUTE87,
PRICING_ATTRIBUTE88,
PRICING_ATTRIBUTE89,
PRICING_ATTRIBUTE90,
PRICING_ATTRIBUTE91,
PRICING_ATTRIBUTE92,
PRICING_ATTRIBUTE93,
PRICING_ATTRIBUTE94,
PRICING_ATTRIBUTE95,
PRICING_ATTRIBUTE96,
PRICING_ATTRIBUTE97,
PRICING_ATTRIBUTE98,
PRICING_ATTRIBUTE99,
PRICING_ATTRIBUTE100,
QUALIFIER_CONTEXT,
QUALIFIER_ATTRIBUTE1,
QUALIFIER_ATTRIBUTE2,
CREATED_BY,
QUALIFIER_ATTRIBUTE3,
CREATION_DATE,
QUALIFIER_ATTRIBUTE4,
QUALIFIER_ATTRIBUTE5,
LAST_UPDATED_BY,
QUALIFIER_ATTRIBUTE6,
LAST_UPDATE_DATE,
QUALIFIER_ATTRIBUTE7,
QUALIFIER_ATTRIBUTE8,
QUALIFIER_ATTRIBUTE9,
QUALIFIER_ATTRIBUTE10,
QUALIFIER_ATTRIBUTE11,
QUALIFIER_ATTRIBUTE12,
QUALIFIER_ATTRIBUTE13,
QUALIFIER_ATTRIBUTE14,
QUALIFIER_ATTRIBUTE15,
QUALIFIER_ATTRIBUTE16,
QUALIFIER_ATTRIBUTE17,
QUALIFIER_ATTRIBUTE18,
QUALIFIER_ATTRIBUTE19,
QUALIFIER_ATTRIBUTE20,
QUALIFIER_ATTRIBUTE21,
QUALIFIER_ATTRIBUTE22,
QUALIFIER_ATTRIBUTE23,
QUALIFIER_ATTRIBUTE24,
QUALIFIER_ATTRIBUTE25,
QUALIFIER_ATTRIBUTE26,
QUALIFIER_ATTRIBUTE27,
QUALIFIER_ATTRIBUTE28,
QUALIFIER_ATTRIBUTE29,
QUALIFIER_ATTRIBUTE30,
QUALIFIER_ATTRIBUTE31,
QUALIFIER_ATTRIBUTE32,
QUALIFIER_ATTRIBUTE33,
QUALIFIER_ATTRIBUTE34,
QUALIFIER_ATTRIBUTE35,
QUALIFIER_ATTRIBUTE36,
QUALIFIER_ATTRIBUTE37,
QUALIFIER_ATTRIBUTE38,
QUALIFIER_ATTRIBUTE39,
QUALIFIER_ATTRIBUTE40,
QUALIFIER_ATTRIBUTE41,
QUALIFIER_ATTRIBUTE42,
QUALIFIER_ATTRIBUTE43,
QUALIFIER_ATTRIBUTE44,
QUALIFIER_ATTRIBUTE45,
QUALIFIER_ATTRIBUTE46,
QUALIFIER_ATTRIBUTE47,
QUALIFIER_ATTRIBUTE48,
QUALIFIER_ATTRIBUTE49,
QUALIFIER_ATTRIBUTE50,
QUALIFIER_ATTRIBUTE51,
QUALIFIER_ATTRIBUTE52,
QUALIFIER_ATTRIBUTE53,
QUALIFIER_ATTRIBUTE54,
QUALIFIER_ATTRIBUTE55,
QUALIFIER_ATTRIBUTE56,
QUALIFIER_ATTRIBUTE57,
QUALIFIER_ATTRIBUTE58,
QUALIFIER_ATTRIBUTE59,
QUALIFIER_ATTRIBUTE60,
QUALIFIER_ATTRIBUTE61,
QUALIFIER_ATTRIBUTE62,
QUALIFIER_ATTRIBUTE63,
QUALIFIER_ATTRIBUTE64,
QUALIFIER_ATTRIBUTE65,
QUALIFIER_ATTRIBUTE66,
QUALIFIER_ATTRIBUTE67,
QUALIFIER_ATTRIBUTE68,
QUALIFIER_ATTRIBUTE69,
QUALIFIER_ATTRIBUTE70,
QUALIFIER_ATTRIBUTE71,
QUALIFIER_ATTRIBUTE72,
QUALIFIER_ATTRIBUTE73,
QUALIFIER_ATTRIBUTE74,
QUALIFIER_ATTRIBUTE75,
QUALIFIER_ATTRIBUTE76,
QUALIFIER_ATTRIBUTE77,
QUALIFIER_ATTRIBUTE78,
QUALIFIER_ATTRIBUTE79,
QUALIFIER_ATTRIBUTE80,
QUALIFIER_ATTRIBUTE81,
QUALIFIER_ATTRIBUTE82,
QUALIFIER_ATTRIBUTE83,
QUALIFIER_ATTRIBUTE84,
QUALIFIER_ATTRIBUTE85,
QUALIFIER_ATTRIBUTE86,
QUALIFIER_ATTRIBUTE87,
QUALIFIER_ATTRIBUTE88,
QUALIFIER_ATTRIBUTE89,
QUALIFIER_ATTRIBUTE90,
QUALIFIER_ATTRIBUTE91,
QUALIFIER_ATTRIBUTE92,
QUALIFIER_ATTRIBUTE93,
QUALIFIER_ATTRIBUTE94,
QUALIFIER_ATTRIBUTE95,
QUALIFIER_ATTRIBUTE96,
QUALIFIER_ATTRIBUTE97,
QUALIFIER_ATTRIBUTE98,
QUALIFIER_ATTRIBUTE99,
QUALIFIER_ATTRIBUTE100,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
OBJECT_VERSION_NUMBER
FROM Okc_Price_Att_Values
WHERE okc_price_att_values.id = p_id;
l_pav_rec.LAST_UPDATED_BY,
l_pav_rec.QUALIFIER_ATTRIBUTE6,
l_pav_rec.LAST_UPDATE_DATE,
l_pav_rec.QUALIFIER_ATTRIBUTE7,
l_pav_rec.QUALIFIER_ATTRIBUTE8,
l_pav_rec.QUALIFIER_ATTRIBUTE9,
l_pav_rec.QUALIFIER_ATTRIBUTE10,
l_pav_rec.QUALIFIER_ATTRIBUTE11,
l_pav_rec.QUALIFIER_ATTRIBUTE12,
l_pav_rec.QUALIFIER_ATTRIBUTE13,
l_pav_rec.QUALIFIER_ATTRIBUTE14,
l_pav_rec.QUALIFIER_ATTRIBUTE15,
l_pav_rec.QUALIFIER_ATTRIBUTE16,
l_pav_rec.QUALIFIER_ATTRIBUTE17,
l_pav_rec.QUALIFIER_ATTRIBUTE18,
l_pav_rec.QUALIFIER_ATTRIBUTE19,
l_pav_rec.QUALIFIER_ATTRIBUTE20,
l_pav_rec.QUALIFIER_ATTRIBUTE21,
l_pav_rec.QUALIFIER_ATTRIBUTE22,
l_pav_rec.QUALIFIER_ATTRIBUTE23,
l_pav_rec.QUALIFIER_ATTRIBUTE24,
l_pav_rec.QUALIFIER_ATTRIBUTE25,
l_pav_rec.QUALIFIER_ATTRIBUTE26,
l_pav_rec.QUALIFIER_ATTRIBUTE27,
l_pav_rec.QUALIFIER_ATTRIBUTE28,
l_pav_rec.QUALIFIER_ATTRIBUTE29,
l_pav_rec.QUALIFIER_ATTRIBUTE30,
l_pav_rec.QUALIFIER_ATTRIBUTE31,
l_pav_rec.QUALIFIER_ATTRIBUTE32,
l_pav_rec.QUALIFIER_ATTRIBUTE33,
l_pav_rec.QUALIFIER_ATTRIBUTE34,
l_pav_rec.QUALIFIER_ATTRIBUTE35,
l_pav_rec.QUALIFIER_ATTRIBUTE36,
l_pav_rec.QUALIFIER_ATTRIBUTE37,
l_pav_rec.QUALIFIER_ATTRIBUTE38,
l_pav_rec.QUALIFIER_ATTRIBUTE39,
l_pav_rec.QUALIFIER_ATTRIBUTE40,
l_pav_rec.QUALIFIER_ATTRIBUTE41,
l_pav_rec.QUALIFIER_ATTRIBUTE42,
l_pav_rec.QUALIFIER_ATTRIBUTE43,
l_pav_rec.QUALIFIER_ATTRIBUTE44,
l_pav_rec.QUALIFIER_ATTRIBUTE45,
l_pav_rec.QUALIFIER_ATTRIBUTE46,
l_pav_rec.QUALIFIER_ATTRIBUTE47,
l_pav_rec.QUALIFIER_ATTRIBUTE48,
l_pav_rec.QUALIFIER_ATTRIBUTE49,
l_pav_rec.QUALIFIER_ATTRIBUTE50,
l_pav_rec.QUALIFIER_ATTRIBUTE51,
l_pav_rec.QUALIFIER_ATTRIBUTE52,
l_pav_rec.QUALIFIER_ATTRIBUTE53,
l_pav_rec.QUALIFIER_ATTRIBUTE54,
l_pav_rec.QUALIFIER_ATTRIBUTE55,
l_pav_rec.QUALIFIER_ATTRIBUTE56,
l_pav_rec.QUALIFIER_ATTRIBUTE57,
l_pav_rec.QUALIFIER_ATTRIBUTE58,
l_pav_rec.QUALIFIER_ATTRIBUTE59,
l_pav_rec.QUALIFIER_ATTRIBUTE60,
l_pav_rec.QUALIFIER_ATTRIBUTE61,
l_pav_rec.QUALIFIER_ATTRIBUTE62,
l_pav_rec.QUALIFIER_ATTRIBUTE63,
l_pav_rec.QUALIFIER_ATTRIBUTE64,
l_pav_rec.QUALIFIER_ATTRIBUTE65,
l_pav_rec.QUALIFIER_ATTRIBUTE66,
l_pav_rec.QUALIFIER_ATTRIBUTE67,
l_pav_rec.QUALIFIER_ATTRIBUTE68,
l_pav_rec.QUALIFIER_ATTRIBUTE69,
l_pav_rec.QUALIFIER_ATTRIBUTE70,
l_pav_rec.QUALIFIER_ATTRIBUTE71,
l_pav_rec.QUALIFIER_ATTRIBUTE72,
l_pav_rec.QUALIFIER_ATTRIBUTE73,
l_pav_rec.QUALIFIER_ATTRIBUTE74,
l_pav_rec.QUALIFIER_ATTRIBUTE75,
l_pav_rec.QUALIFIER_ATTRIBUTE76,
l_pav_rec.QUALIFIER_ATTRIBUTE77,
l_pav_rec.QUALIFIER_ATTRIBUTE78,
l_pav_rec.QUALIFIER_ATTRIBUTE79,
l_pav_rec.QUALIFIER_ATTRIBUTE80,
l_pav_rec.QUALIFIER_ATTRIBUTE81,
l_pav_rec.QUALIFIER_ATTRIBUTE82,
l_pav_rec.QUALIFIER_ATTRIBUTE83,
l_pav_rec.QUALIFIER_ATTRIBUTE84,
l_pav_rec.QUALIFIER_ATTRIBUTE85,
l_pav_rec.QUALIFIER_ATTRIBUTE86,
l_pav_rec.QUALIFIER_ATTRIBUTE87,
l_pav_rec.QUALIFIER_ATTRIBUTE88,
l_pav_rec.QUALIFIER_ATTRIBUTE89,
l_pav_rec.QUALIFIER_ATTRIBUTE90,
l_pav_rec.QUALIFIER_ATTRIBUTE91,
l_pav_rec.QUALIFIER_ATTRIBUTE92,
l_pav_rec.QUALIFIER_ATTRIBUTE93,
l_pav_rec.QUALIFIER_ATTRIBUTE94,
l_pav_rec.QUALIFIER_ATTRIBUTE95,
l_pav_rec.QUALIFIER_ATTRIBUTE96,
l_pav_rec.QUALIFIER_ATTRIBUTE97,
l_pav_rec.QUALIFIER_ATTRIBUTE98,
l_pav_rec.QUALIFIER_ATTRIBUTE99,
l_pav_rec.QUALIFIER_ATTRIBUTE100,
l_pav_rec.LAST_UPDATE_LOGIN,
l_pav_rec.PROGRAM_APPLICATION_ID,
l_pav_rec.PROGRAM_ID,
l_pav_rec.PROGRAM_UPDATE_DATE,
l_pav_rec.REQUEST_ID,
l_pav_rec.OBJECT_VERSION_NUMBER;
SELECT
ID,
CHR_ID,
CLE_ID,
FLEX_TITLE,
PRICING_CONTEXT,
PRICING_ATTRIBUTE1,
PRICING_ATTRIBUTE2,
PRICING_ATTRIBUTE3,
PRICING_ATTRIBUTE4,
PRICING_ATTRIBUTE5,
PRICING_ATTRIBUTE6,
PRICING_ATTRIBUTE7,
PRICING_ATTRIBUTE8,
PRICING_ATTRIBUTE9,
PRICING_ATTRIBUTE10,
PRICING_ATTRIBUTE11,
PRICING_ATTRIBUTE12,
PRICING_ATTRIBUTE13,
PRICING_ATTRIBUTE14,
PRICING_ATTRIBUTE15,
PRICING_ATTRIBUTE16,
PRICING_ATTRIBUTE17,
PRICING_ATTRIBUTE18,
PRICING_ATTRIBUTE19,
PRICING_ATTRIBUTE20,
PRICING_ATTRIBUTE21,
PRICING_ATTRIBUTE22,
PRICING_ATTRIBUTE23,
PRICING_ATTRIBUTE24,
PRICING_ATTRIBUTE25,
PRICING_ATTRIBUTE26,
PRICING_ATTRIBUTE27,
PRICING_ATTRIBUTE28,
PRICING_ATTRIBUTE29,
PRICING_ATTRIBUTE30,
PRICING_ATTRIBUTE31,
PRICING_ATTRIBUTE32,
PRICING_ATTRIBUTE33,
PRICING_ATTRIBUTE34,
PRICING_ATTRIBUTE35,
PRICING_ATTRIBUTE36,
PRICING_ATTRIBUTE37,
PRICING_ATTRIBUTE38,
PRICING_ATTRIBUTE39,
PRICING_ATTRIBUTE40,
PRICING_ATTRIBUTE41,
PRICING_ATTRIBUTE42,
PRICING_ATTRIBUTE43,
PRICING_ATTRIBUTE44,
PRICING_ATTRIBUTE45,
PRICING_ATTRIBUTE46,
PRICING_ATTRIBUTE47,
PRICING_ATTRIBUTE48,
PRICING_ATTRIBUTE49,
PRICING_ATTRIBUTE50,
PRICING_ATTRIBUTE51,
PRICING_ATTRIBUTE52,
PRICING_ATTRIBUTE53,
PRICING_ATTRIBUTE54,
PRICING_ATTRIBUTE55,
PRICING_ATTRIBUTE56,
PRICING_ATTRIBUTE57,
PRICING_ATTRIBUTE58,
PRICING_ATTRIBUTE59,
PRICING_ATTRIBUTE60,
PRICING_ATTRIBUTE61,
PRICING_ATTRIBUTE62,
PRICING_ATTRIBUTE63,
PRICING_ATTRIBUTE64,
PRICING_ATTRIBUTE65,
PRICING_ATTRIBUTE66,
PRICING_ATTRIBUTE67,
PRICING_ATTRIBUTE68,
PRICING_ATTRIBUTE69,
PRICING_ATTRIBUTE70,
PRICING_ATTRIBUTE71,
PRICING_ATTRIBUTE72,
PRICING_ATTRIBUTE73,
PRICING_ATTRIBUTE74,
PRICING_ATTRIBUTE75,
PRICING_ATTRIBUTE76,
PRICING_ATTRIBUTE77,
PRICING_ATTRIBUTE78,
PRICING_ATTRIBUTE79,
PRICING_ATTRIBUTE80,
PRICING_ATTRIBUTE81,
PRICING_ATTRIBUTE82,
PRICING_ATTRIBUTE83,
PRICING_ATTRIBUTE84,
PRICING_ATTRIBUTE85,
PRICING_ATTRIBUTE86,
PRICING_ATTRIBUTE87,
PRICING_ATTRIBUTE88,
PRICING_ATTRIBUTE89,
PRICING_ATTRIBUTE90,
PRICING_ATTRIBUTE91,
PRICING_ATTRIBUTE92,
PRICING_ATTRIBUTE93,
PRICING_ATTRIBUTE94,
PRICING_ATTRIBUTE95,
PRICING_ATTRIBUTE96,
PRICING_ATTRIBUTE97,
PRICING_ATTRIBUTE98,
PRICING_ATTRIBUTE99,
PRICING_ATTRIBUTE100,
QUALIFIER_CONTEXT,
QUALIFIER_ATTRIBUTE1,
QUALIFIER_ATTRIBUTE2,
QUALIFIER_ATTRIBUTE3,
QUALIFIER_ATTRIBUTE4,
QUALIFIER_ATTRIBUTE5,
QUALIFIER_ATTRIBUTE6,
QUALIFIER_ATTRIBUTE7,
QUALIFIER_ATTRIBUTE8,
QUALIFIER_ATTRIBUTE9,
QUALIFIER_ATTRIBUTE10,
QUALIFIER_ATTRIBUTE11,
QUALIFIER_ATTRIBUTE12,
QUALIFIER_ATTRIBUTE13,
QUALIFIER_ATTRIBUTE14,
QUALIFIER_ATTRIBUTE15,
QUALIFIER_ATTRIBUTE16,
QUALIFIER_ATTRIBUTE17,
QUALIFIER_ATTRIBUTE18,
QUALIFIER_ATTRIBUTE19,
QUALIFIER_ATTRIBUTE20,
QUALIFIER_ATTRIBUTE21,
QUALIFIER_ATTRIBUTE22,
QUALIFIER_ATTRIBUTE23,
QUALIFIER_ATTRIBUTE24,
QUALIFIER_ATTRIBUTE25,
QUALIFIER_ATTRIBUTE26,
QUALIFIER_ATTRIBUTE27,
QUALIFIER_ATTRIBUTE28,
QUALIFIER_ATTRIBUTE29,
QUALIFIER_ATTRIBUTE30,
QUALIFIER_ATTRIBUTE31,
QUALIFIER_ATTRIBUTE32,
QUALIFIER_ATTRIBUTE33,
QUALIFIER_ATTRIBUTE34,
QUALIFIER_ATTRIBUTE35,
QUALIFIER_ATTRIBUTE36,
QUALIFIER_ATTRIBUTE37,
QUALIFIER_ATTRIBUTE38,
QUALIFIER_ATTRIBUTE39,
QUALIFIER_ATTRIBUTE40,
QUALIFIER_ATTRIBUTE41,
QUALIFIER_ATTRIBUTE42,
QUALIFIER_ATTRIBUTE43,
QUALIFIER_ATTRIBUTE44,
QUALIFIER_ATTRIBUTE45,
QUALIFIER_ATTRIBUTE46,
QUALIFIER_ATTRIBUTE47,
QUALIFIER_ATTRIBUTE48,
QUALIFIER_ATTRIBUTE49,
QUALIFIER_ATTRIBUTE50,
QUALIFIER_ATTRIBUTE51,
QUALIFIER_ATTRIBUTE52,
QUALIFIER_ATTRIBUTE53,
QUALIFIER_ATTRIBUTE54,
QUALIFIER_ATTRIBUTE55,
QUALIFIER_ATTRIBUTE56,
QUALIFIER_ATTRIBUTE57,
QUALIFIER_ATTRIBUTE58,
QUALIFIER_ATTRIBUTE59,
QUALIFIER_ATTRIBUTE60,
QUALIFIER_ATTRIBUTE61,
QUALIFIER_ATTRIBUTE62,
QUALIFIER_ATTRIBUTE63,
QUALIFIER_ATTRIBUTE64,
QUALIFIER_ATTRIBUTE65,
QUALIFIER_ATTRIBUTE66,
QUALIFIER_ATTRIBUTE67,
QUALIFIER_ATTRIBUTE68,
QUALIFIER_ATTRIBUTE69,
QUALIFIER_ATTRIBUTE70,
QUALIFIER_ATTRIBUTE71,
QUALIFIER_ATTRIBUTE72,
QUALIFIER_ATTRIBUTE73,
QUALIFIER_ATTRIBUTE74,
QUALIFIER_ATTRIBUTE75,
QUALIFIER_ATTRIBUTE76,
QUALIFIER_ATTRIBUTE77,
QUALIFIER_ATTRIBUTE78,
QUALIFIER_ATTRIBUTE79,
QUALIFIER_ATTRIBUTE80,
QUALIFIER_ATTRIBUTE81,
QUALIFIER_ATTRIBUTE82,
QUALIFIER_ATTRIBUTE83,
QUALIFIER_ATTRIBUTE84,
QUALIFIER_ATTRIBUTE85,
QUALIFIER_ATTRIBUTE86,
QUALIFIER_ATTRIBUTE87,
QUALIFIER_ATTRIBUTE88,
QUALIFIER_ATTRIBUTE89,
QUALIFIER_ATTRIBUTE90,
QUALIFIER_ATTRIBUTE91,
QUALIFIER_ATTRIBUTE92,
QUALIFIER_ATTRIBUTE93,
QUALIFIER_ATTRIBUTE94,
QUALIFIER_ATTRIBUTE95,
QUALIFIER_ATTRIBUTE96,
QUALIFIER_ATTRIBUTE97,
QUALIFIER_ATTRIBUTE98,
QUALIFIER_ATTRIBUTE99,
QUALIFIER_ATTRIBUTE100,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
OBJECT_VERSION_NUMBER
FROM Okc_Price_Att_Values_V
WHERE okc_price_att_values_v.id = p_id;
l_pavv_rec.LAST_UPDATED_BY,
l_pavv_rec.LAST_UPDATE_DATE,
l_pavv_rec.LAST_UPDATE_LOGIN,
l_pavv_rec.PROGRAM_APPLICATION_ID,
l_pavv_rec.PROGRAM_ID,
l_pavv_rec.PROGRAM_UPDATE_DATE,
l_pavv_rec.REQUEST_ID,
l_pavv_rec.OBJECT_VERSION_NUMBER;
IF (l_pavv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
l_pavv_rec.last_updated_by := NULL;
IF (l_pavv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
l_pavv_rec.last_update_date := NULL;
IF (l_pavv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
l_pavv_rec.last_update_login := NULL;
IF (l_pavv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
l_pavv_rec.program_update_date := NULL;