APPS.PAY_CON_SHD SQL Statements

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

Line: 70

    select
		contr_history_id,
	person_id,
	date_from,
	date_to,
	contr_type,
	business_group_id,
	legislation_code,
	amt_contr,
	max_contr_allowed,
	includable_comp,
	tax_unit_id,
	source_system,
	contr_information_category,
	contr_information1,
	contr_information2,
	contr_information3,
	contr_information4,
	contr_information5,
	contr_information6,
	contr_information7,
	contr_information8,
	contr_information9,
	contr_information10,
	contr_information11,
	contr_information12,
	contr_information13,
	contr_information14,
	contr_information15,
	contr_information16,
	contr_information17,
	contr_information18,
	contr_information19,
	contr_information20,
	contr_information21,
	contr_information22,
	contr_information23,
	contr_information24,
	contr_information25,
	contr_information26,
	contr_information27,
	contr_information28,
	contr_information29,
	contr_information30,
	object_version_number
    from	pay_us_contribution_history
    where	contr_history_id = p_contr_history_id;

Line: 184

    select 	contr_history_id,
	person_id,
	date_from,
	date_to,
	contr_type,
	business_group_id,
	legislation_code,
	amt_contr,
	max_contr_allowed,
	includable_comp,
	tax_unit_id,
	source_system,
	contr_information_category,
	contr_information1,
	contr_information2,
	contr_information3,
	contr_information4,
	contr_information5,
	contr_information6,
	contr_information7,
	contr_information8,
	contr_information9,
	contr_information10,
	contr_information11,
	contr_information12,
	contr_information13,
	contr_information14,
	contr_information15,
	contr_information16,
	contr_information17,
	contr_information18,
	contr_information19,
	contr_information20,
	contr_information21,
	contr_information22,
	contr_information23,
	contr_information24,
	contr_information25,
	contr_information26,
	contr_information27,
	contr_information28,
	contr_information29,
	contr_information30,
	object_version_number
    from	pay_us_contribution_history
    where	contr_history_id = p_contr_history_id
    for	update nowait;