APPS.PAY_SBT_SHD SQL Statements

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

Line: 59

    select
		balance_type_id,
	template_id,
	assignment_remuneration_flag,
	balance_name,
	balance_uom,
	currency_code,
	comments,
	reporting_name,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
	jurisdiction_level,
	tax_type,
	exclusion_rule_id,
	object_version_number,
        category_name,
        base_balance_type_id,
        base_balance_name,
        input_value_id
    from	pay_shadow_balance_types
    where	balance_type_id = p_balance_type_id;

Line: 166

    select 	balance_type_id,
	template_id,
	assignment_remuneration_flag,
	balance_name,
	balance_uom,
	currency_code,
	comments,
	reporting_name,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20,
	jurisdiction_level,
	tax_type,
	exclusion_rule_id,
	object_version_number,
        category_name,
        base_balance_type_id,
        base_balance_name,
        input_value_id
    from	pay_shadow_balance_types
    where	balance_type_id = p_balance_type_id
    for	update nowait;