DBA Data[Home] [Help]

APPS.PQH_CEA_SHD SQL Statements

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

Line: 53

    select
		copy_entity_attrib_id,
	copy_entity_txn_id,
	row_type_cd,
	information_category,
	information1,
	information2,
	information3,
	information4,
	information5,
	information6,
	information7,
	information8,
	information9,
	information10,
	information11,
	information12,
	information13,
	information14,
	information15,
	information16,
	information17,
	information18,
	information19,
	information20,
	information21,
	information22,
	information23,
	information24,
	information25,
	information26,
	information27,
	information28,
	information29,
	information30,
        check_information1,
        check_information2,
        check_information3,
	object_version_number
    from	pqh_copy_entity_attribs
    where	copy_entity_attrib_id = p_copy_entity_attrib_id;
Line: 161

    select 	copy_entity_attrib_id,
	copy_entity_txn_id,
	row_type_cd,
	information_category,
	information1,
	information2,
	information3,
	information4,
	information5,
	information6,
	information7,
	information8,
	information9,
	information10,
	information11,
	information12,
	information13,
	information14,
	information15,
	information16,
	information17,
	information18,
	information19,
	information20,
	information21,
	information22,
	information23,
	information24,
	information25,
	information26,
	information27,
	information28,
	information29,
	information30,
        check_information1,
        check_information2,
        check_information3,
	object_version_number
    from	pqh_copy_entity_attribs
    where	copy_entity_attrib_id = p_copy_entity_attrib_id
    for	update nowait;